difference between primary key and unique key
Answers
Answered by
0
Primary key and unique key is same... It is a term of DBMS( Access ).. Primary key is a key which has some uniqueness and helps in non duplicating of data.
dikshaverma4you:
Hey plzz mark it as best...
Answered by
0
primary key:-
Can be only one in a table
In some DBMS it cannot be NULL - e.g. MySQL adds NOT NULL
Primary Key is a unique key identifier of the record
unique key:-
Can be more than one unique key in one table
Unique key can have null values
It can be a candidate key
Unique key can be null and may not be unique
Can be only one in a table
In some DBMS it cannot be NULL - e.g. MySQL adds NOT NULL
Primary Key is a unique key identifier of the record
unique key:-
Can be more than one unique key in one table
Unique key can have null values
It can be a candidate key
Unique key can be null and may not be unique
Similar questions