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
What is self contained sub query?
What is 3nf normalization form?
How to define output parameters in stored procedures?
What are the restrictions that views have to follow?
What the different components of Replication and what is their use?
What is transact-sql ddl trigger?
What are the system database in sql server 2005?
User wants only to display only pdf as export option in report manager. How to achieve this?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
Disadvantages of the indexes?
What is log ldf?
What is advantage data architect?
What are parameterized reports? What are cascading parameters in ssrs reports?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
What is SQL Azure Fabric?
