what is the difference between unique and primary key
Answer Posted / divyarao
primary key accepts only values which has no duplication ,and does not accept null values . for a a table there should be only one primary key constraint.
whereas in unique key ,it accepts null values .here also there should not be any duplication ,a table may have more than one unique key constarint
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between hashed file stage and sequential file stage in relates to datastage server?
Is declare cursor executable?
What is a data type in a database?
How to debug stored procedures?
What is 1nf?
How rdbms is different from dbms?
What is snow flake schema design in database? What's the difference between star and snow flake schema?
Explain degree of a relation?
What is tabular form?
What is implicit cursor in dbms?
Is access a database program?
How to detect the server version?
What is the purpose of a field in a database?
What are good databases?
What is a driver in programming?