What's the difference between a primary key and a unique key?
Answer Posted / amit
-Both are Unique means they do not accept duplicate value.
-Primary key by default Clustered Index where as Unique Key
is a Non-Clustered Index.
-Primary Key does not accept null value where as Unique Key
accept only one Null Value.
-A table can have only one Primary Key where as A table can
have multiple Unique Key.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can binary strings be converted into numeric or float data types?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
explain different types of cursors? : Sql server database administration
What is the difference between mysql and mysqli?
how you can configure a running aggregate in SSRS?
what is difference between view and Dip.
Why are you getting errors when creating a new odbc dsn?
Explain about analysis services?
What is the sql case statement used for? Explain with an example?
what types of replication are supported in sql server? : Sql server database administration
How will you add a dimension to cube? : sql server analysis services, ssas
Can we use custom code in ssrs?
Which data type columns are the best candidates for full-text indexing?
How is SQL Azure different than SQL server?
How do you improve the performance of a SQL Azure Database?