is there more the two primary key in a single table?
- 26 Answers
- 28759 Views
- Eforce, Systematix, I also Faced
- E-Mail Answers
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 do you mean by stored techniques? How would we use it?
What are sql server procedures?
What is the significance of master, tempdb and model databases?
Explain sql server authentication modes?
How to retrieve field values using mssql_result()?
How to automatically create a log when an exception is being received into SQL Server?
What is 2nf in normalization?
Can select statements be used on views in ms sql server?
how can you attach more than 20 ldf files in sql server
Define outer join?
Explain what is lock escalation and what is its purpose?
What command do we use to rename a db, a table and a column?
What is meant by datasource?
How to Sync Two SQL Azure Databases?
What is importing utility?
