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
how would you troubleshoot blocking? : Sql server database administration
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
What are window functions in sql server?
What is a db view?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
What are null values in ms sql server?
What is model database? : SQL Server Architecture
What are the operating modes in which database mirroring runs?
What is bcp? When does it used?
How can you insert values in multiple rows using one Insert statement?
How to find related tables in sql server?
How to change the name of a database user?
what is the system function to get the current user's user id? : Sql server database administration
what is a correlated sub-query? : Sql server database administration
What is difference between commit and rollback when used in transactions?
