Interested to Buy Any Domain ? << Click Here >> for more details...
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
Define msdb database?
What is the exact numeric data type in sql?
Which are the third-party tools used in sql server and why would you use them?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
What is command parameter in ssrs?
in the physical file layout, where should the transaction log be stored in relation to the data file?
Do you know how to make remote connection in database?
How can I create a report based on a query? : sql server management studio
define and explain the differences between clustered and non-clustered indexes.
What is Cross Join and in which scenario do we use Cross Join?
What is usually the first word in a sql query?
What are out-of-range errors with date and time literals?
What triggers long term care?
Explain how would you store your query in an SSRS report or a Database server?
How to create a user name in a database?
