what is difference between primary key and Unique

Answer Posted / suresh kaudi

Primary key : Not Accept null values
Unique key : Accept Onley one null value
When you Make Primary key In a table cluster index create
Automatically mean default.
Unique Key create Automatically non-cluster index

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 table constraint?

727


How do I perform an unattended install of sql server 2000?

757


Why should you use or avoid select * statements?

734


How to make conditional sum in ssrs?

148


Mention the command used to rename the database.

723






What are magic tables in sql server?

785


Where are sql server usernames and passwords stored in the sql server?

789


How to loop through the result set with @@fetch_status?

829


Is sql server 2016 free?

695


Why use “in” clause in sql server?

725


What is the process of indexing?

705


How do I install sql server?

620


How do you test your database? : sql server database administration

715


How to insert new line characters into strings?

721


What do you mean by stored techniques? How would we use it?

764