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


Please Help Members By Posting Answers For Below Questions

What is the difference between hashed file stage and sequential file stage in relates to datastage server?

854


Is declare cursor executable?

702


What is a data type in a database?

703


How to debug stored procedures?

715


What is 1nf?

706


How rdbms is different from dbms?

667


What is snow flake schema design in database? What's the difference between star and snow flake schema?

629


Explain degree of a relation?

665


What is tabular form?

692


What is implicit cursor in dbms?

756


Is access a database program?

644


How to detect the server version?

701


What is the purpose of a field in a database?

641


What are good databases?

693


What is a driver in programming?

706