what is difference between primary key and Unique

Answer Posted / hari

Primary key : Doen't allow null values
Unique key : allow one null value
Primary key create cluster index
Unique Key create non-cluster index

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why Master database is required?

598


How do you create a clustered index?

528


Explain what are sparse columns?

566


What is a self join in sql server?

592


What is the log shipping?

582






What is normalization and denormalization in sql server?

535


When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

495


after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

1683


Can you import Microsoft Excel data to SSRS?

89


How to generate create function script on an existing function?

587


What is the purpose of floor function?

539


Difference between report and query parameter.

598


What is partitioned view?

523


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1508


How to integrate the ssrs reports in application?

540