what is difference between primary key and Unique

Answer Posted / thaqi

unique key: allows NULL values and doesn't allow duplicate
values.

primary key:doesn't allow both NULL and duplicate values

Is This Answer Correct ?    11 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to define testing of network layers? : Sql server database administration

658


Explain relational data?

704


What is constraints and its types?

678


Explain the dbcc pintable command when would you use it?

686


explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

814






How can you insert values in multiple rows using one Insert statement?

802


How do I find the default sql server instance?

695


Why I can not enter 0.001 second in date and time literals in ms sql server?

750


What is difference between clustered index and non clustered index?

801


How to use order by with union operators in ms sql server?

756


How do database indexes work?

723


Is mysql better than sql server?

736


what is a join and explain different types of joins? : Sql server database administration

712


How to enter binary string literals in ms sql server?

822


How does stuff differ from the replace function?

738