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
Does view occupy space?
What is a not null constraint?
What is data file in computer?
How to delete a login name in ms sql server?
Tell me in brief how sql server enhances scalability of the database system?
How many tables can be joined in SQL Server?
Please differentiate between a local and a global temporary table?
How do I make a resultset scrollable?
Where do you find the default Index fill factor and how to change it?
what is hash nonclustered index
What is the use of for clause?
Explain the concept of recursive stored procedure.
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
Does partitioning improve performance sql server?
List some major differences between triggers and stored procedures?
