What's the difference between a primary key and a unique key?

Answer Posted / awdhesh

By default Primary Key Create Cluster index while unique
ker create non cluster index

Is This Answer Correct ?    17 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What command do we use to rename a database?

609


Why do we use trigger?

552


How to reaname table name without using sp_Rename in sql server..?

525


what is the difference between delete table and truncate table commands? : Sql server database administration

517


Can you create a logon trigger in sql server 2005 express edition?

569






How do you use a subquery to find records that exist in one table and do not exist in another?

546


What is federation member?

91


What is correlated subquery in sql server?

555


What is difference between views and stored procedures?

507


What do you understand by recursive stored procedures?

561


What are sub reports?

149


How to use the inserted and deleted pseudo tables?

540


To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

527


Explain subquery and state its properties?

545


Do you know the capabilities of cursors?

533