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

Answer Posted / ramneet

Primary can be used in foregin key but unique key does not
used.

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to sort query output in descending order in ms sql server?

532


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

594


What is the difference between char and varchar2 datatype in sql?

533


Can we return Data from 4(more than 1) tables in stored procedure?

607


SQL Server Architecture ?

1919






How will you know when statistics on a table are obsolete?

597


Write a sql query to delete duplicate records from a table called table1

579


How do you size a resultset?

494


What are different types of collation sensitivity?

534


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

582


What triggers long term care?

552


How to find Duplicate Records In table?

579


What is attribute? : sql server analysis services, ssas

578


What is a fan-out query in SQL Azure?

99


How to optimize stored procedures in sql server?

614