yes,you can only create one clustered index on a table.

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

Question Posted / samrat sen

Answer Posted / samrat sen

Is This Answer Correct ?

10 Yes

12 No

Please Help Members By Posting Answers For Below Questions

What happens if you delete a table that is used by a view?

990

What are the different authentication modes in sql server?

1124

How many clustered indexes there can be on table ?

1040

How to make remote connection in database?

1010

Can an entity have two primary keys?

982

What are the basic features of a trigger in ms sql server?

1199

What is the synonym of join?

963

What is the difference between varchar and nvarchar?

942

What do you understand by the analysis services in sql server?

942

How do I determine how many instances of sql server are installed on a computer?

1008

What do you mean by an execution plan? Why is it used?

1029

Is it possible to replicate data from sql server to oracle? : sql server replication

1098

Is sql server a database?

1003

Define master database?

1078

What is an execution plan?

1155