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
What is history table in sql server?
What is a functions and types in sql server?
How to create new databases with "create database" statements?
what is dbcc? : Sql server database administration
What is TDS(Tabular Data Stream) Gateway?
What are SSL and TSL protocols?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
What is a livelock?
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
Explain syntax for viewing trigger?
How does Report Builder support Analysis Services cubes?
How do clustered indexes store data?
Explain what are magic tables in sql server?
Explain how dts is used to extract, transform and consolidate data?
What is standby servers? Explain types of standby servers.
