As when we create one primary key in table, clustered index will be created. Same way if we have two primary keys in table which index will be get created?

Post

View All

Virag Jain

As when we create one primary key in table, clustered index will be created. Same way if we have two primary keys in table which index will be get created?

By Virag Jain in SQL Server on Jul 17 2007

0
6.8k
1

Post Your Answer

Jul, 2007 17
in sql server a table can have a maximum of one primary key.a primary key can be constructed on one or more columns.maximum number of columns on which a primary key can be constructed is 16.when a primary key is constructed on multiple columns, such a primary key is known a composite primary key.so finally no question of a table having more than one primary key.so a table cannot have more than one clustered index.
- 0