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 happens if time-only values are provided as date and time literals?
Is null vs coalesce?
What are joins in sql and what are the different types of joins?
What is the difference between grant and with grant while giving permissions to the user?
What is #temp and @table variable in SQL server?
How to assign new column names in a view?
Why we should not use triggers?
What program is used to store the data source file?
How to create a simple stored procedure in ms sql server?
How to optimize stored procedure optimization?
What is the need for group functions in sql?
Explain about nested stored procedure?
How to view existing indexes on an given table using sp_help?
Explain the database you used in your final year project?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
