Clustered index based on Primary Key. So if we create a PK, automatically

WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER?

Question Posted / muthu

Answer Posted / muthu

Clustered index based on Primary Key. So if we create a PK,
automatically Clustered Index will be created. So only one
CI available for a table.

Is This Answer Correct ?

10 Yes

14 No

Please Help Members By Posting Answers For Below Questions

What is a cache in ssrs?

134

What the different components in replication and what is their use?

955

Can sql server 2016 run on windows 7?

923

What does nvl stand for?

946

What is measure group, measure? : sql server analysis services, ssas

1018

What is index in an assignment?

955

What does the not null constraint do?

1092

What are different types of views?

948

What is the default value of an integer data type in sql server 2005?

954

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

1024

How to update a field in SQL after ALTERING a row?

1235

What is difference between equi join and natural join?

1042

Tell me what is difference between view and materialized view?

941

Which data type columns are the best candidates for full-text indexing?

971

What is subquery in sql?

1073