Interested to Buy Any Domain ? << Click Here >> for more details...
is there more the two primary key in a single table?
- 26 Answers
- 33416 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
How to transfer an existing table from one schema to another schema in ms sql server?
What is data source view or dsv? : sql server analysis services, ssas
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
Can you create a logon trigger in sql server 2005 express edition?
What will happen if a column containing char type data is changed to the nchar data type?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
Explain logical operators in sql server?
How to rename databases in ms sql server?
What are the advantages of sql stored procedure?
What are sparse columns?
How the authentication mode can be changed?
What are character string data types in ms sql server?
How to apply filtering criteria at group level with the having clause in ms sql server?
What is data modeling and Reterminal integrity?
How we can refresh the view?
