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 triggers and stored procedures?

927

Explain about the command-line tool SQLCMD?

1066

What are the difference between primary keys and foreign keys?

952

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

960

What are the system database in sql server 2005?

1027

what is a check constraint?

1074

What is a field in a table?

1019

What is transact-sql ddl trigger?

1086

How to defragment indexes with alter index ... Reorganize?

1062

what is bit datatype? : Sql server database administration

897

List out the difference between union and union all in sql server?

970

What are the reporting services components?

142

explain databases and sql server databases architecture? : Sql server database administration

942

What is inner join? Explain with an example?

1196

Is sql server difficult to learn?

905