What's the difference between a primary key and a unique key?
Answer Posted / hameed
Primary key does not allow any null value in a table where
as Unique key allows only one null value
Primary key is by default a Clustered Index where as Unique
key is a non-clustered index
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
Explain different types of collation sensitivity?
What is a DBMS, query, SQL?
How to attach adventureworkslt physical files to the server?
what do you understand by change data capture?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
How do you delete a trigger?
What is sql server management studio? : sql server management studio
What is the template in sql?
What is the use of commit?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
How to list all triggers in the database with sys.triggers in ms sql server?
What is join query?
How to receive returning result from a query?
How to make a column nullable?