How are the unique and primary key constraints different?



How are the unique and primary key constraints different?..

Answer / Aditya

The main difference between a unique constraint and a primary key constraint is that a table can have multiple unique constraints, while it can only have one primary key. Both constraints ensure that no duplicate values exist in the specified column(s), but the primary key provides additional features such as automatic enforcement of referential integrity.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1 Answers  


What is the benefit of normalization?

1 Answers  


Why people hate cursor?

1 Answers  


What the class forname () does?

1 Answers  


How to enable/disable indexes?

1 Answers  


What purpose does the model database server?

1 Answers  


What is the difference between a check constraint and a rule?

1 Answers  


can any body tell me how to know the password of current user in sql server

1 Answers   Crea, HCL,


How many triggers you can have on a table?

1 Answers  


What is an indexing technique?

1 Answers  


What is the difference between local table and global table

1 Answers   CarrizalSoft Technologies, Polaris,


What is difference between primary key and foreign key?

1 Answers  


Categories