Answer Posted / samar
Primary key is also known as clusterd index which is
physical structure .And noncluster index is logical
structure .
therefore Primary key cant be a nonclustered index. and
when we are creating primary key on a table system
understands it as creation of clustered index.
this is the reason one table can have one primary key
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What command must you use to include the not null constraint after a table has already been created?
What is sql service broker?
How do I debug a stored procedure in sql server?
Explain what are the basic functions for master, msdb, model, tempdb databases?
What is query parameter in ssrs?
What is the difference between clustered and non-clustered indexes in ms sql server?
What is the difference between count and distinct count?
Define ACID properties in a Database?
What is sql server transaction log file?
What is the maximum size of a dimension? : sql server analysis services, ssas
When we should use @@error?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What is exporting and importing utility?
What is the difference between deallocate cursor and close cursor?
