What's the difference between a primary key and a unique
key?
Answer Posted / gowthami radhakrishnana
1)primary key uses clustered index
unique key uses non-clustered index
2)primary key doesn't allow null values
but unique allows one null value
3)there is only one primary key but more than one unique
keys
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
what is raid? : Sql server database administration
What are approximate numeric data types in ms sql server?
How can a database be repaired?
mention different types of relationships in the dbms?
What does man by sql wildcard characters in sql server?
optimization techinques
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
What are Spatial data types in SQL Server 2008
What is application role in sql server database security? : sql server security
How to connect Azure federated root database and apply federation in entity framework?
explain databases and sql server databases architecture? : Sql server database administration
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
What is the difference between ‘having’ clause and a ‘where’ clause?
What is history table in sql server?
What does the not null constraint do?