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?
Virag Jain
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.