Answer Posted / suresh kaudi
Primary Key: Not allow null values,when we make primary key
automatically create cluster index,primary key we make
other foreign key.
Unique key: allow one null value,we can't make it foreign
key to other table.here we cane make only non-cluster index
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
Are resultset updatable?
Where sql server usernames and passwords are stored in a sql server?
What do I need to start working with sql studio? : sql server management studio
What are the system database in sql server 2008?
What is oltp (online transaction processing)?
List the types of recovery model available in sql server?
How network traffic be reduced by using the stored procedure?
How to create a simple stored procedure in ms sql server?
What is model database in sql server?
How to create a store procedure with encryption?
What is the fillfactor concept in indexes?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
Why use identity in sql server?
what are candidate key, alternate key and composite key? : Sql server database administration