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

Does sql server use t sql?

951

Is sql server difficult to learn?

862

Tell me the use of keyword with encryption. Create a store procedure with encryption?

960

Explain in details security in SQL azure?

121

List out different types of normalizations in sql server and explain each of them?

882

How many full-text indexes can a table have?

925

What do mean by xml datatype?

1004

What are the 2 types of classifications of constraints in the sql server?

1041

What is a collation?

1032

What is a user-defined function in the sql server and what is its advantage?

1042

What is use of except clause? How does it differ from not in clause?

960

What samples and sample databases are provided by microsoft?

968

How many types of dimensions are there and what are they? : sql server analysis services, ssas

1023

How to reaname table name without using sp_Rename in sql server..?

935

How to update muliple row in single query?

998