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

Answer Posted / ramneet

There is one more diff b/w primary key and unique key that
there is only one primary key in a table but there are more
then one unique keys in a table.

Is This Answer Correct ?    11 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is normalization? What number of normalization shapes are there?

714


How do you drop an index?

583


You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

657


What are the differences between left join and inner join in sql server?

685


what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

622






What is “asynchronous” communication in sql server service broker?

635


How can you append an identity column to a temporary table?

524


What is the difference between for trigger and after trigger?

629


What is difference between global temporary tables and local temporary tables?

768


How to drop existing views from a database in ms sql server?

630


What is the difference between push and pull subscription? : sql server replication

717


What structure can you implement for the database to speed up table reads?

828


What is a hint?

658


What is a natural primary key?

610


What is create command?

610