is there more the two primary key in a single table?
Answer Posted / sudheer gowlikar
we cannot have more than one primary key on a table since
primary will create a clustered index and we can have only
1 clustered index on a table since clustered index will
sort data in data pages and the data sorted in one way
rather sorting number of ways.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are policy management terms?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What do you understand by replication in sql server? Mention the different types of replication in sql server.
wat wil hapn if we give the both read and deny read permission to user?
What is Replication?
What are the different types of replication are there in sql server 2000?
How to create function with parameter in sql server?
What are the filtered indexes?
What do we have to check in database testing?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
Why normalization is used?
How to perform backup for certificates in sql server? : sql server security
How to insert data into an existing table?
What is the purpose of linked server configuration in sql server?
What is Transparent Data Encryption?