Answer Posted / sivasankar k.c
Primary key: it is clustered index. it not allows null
values. Only one primary in each table.
Unique Key: it is non clustered index. Unique key allows
null values.its allows only one null value. More than one
unique key in table.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
Can the query output be sorted by multiple columns in ms sql server?
How do I shrink an ldf file?
What are the new data types are introduced in sql 2000?
what is the difference between delete table and truncate table commands? : Sql server database administration
What is an index in sql?
What are the steps to insert a table?
How can we check the sql server version?
What happens on checkpoint?
What is a database in ms sql server?
What is the difference between coalesce() & isnull()?
What are extended events in sql server?
What are the difference between clustered and a non-clustered index?
How to use wildcard characters in like operations in ms sql server?
Explain a checkpoint?
What stored by the master?