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

Do you know what is fill factor and pad index?

569

What is difference between sql and sql server?

547

Please explain go command in sql server?

600

Explain relational data?

553

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

528

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

607

How to change the name of a database user?

553

What is sql server programming?

558

Explain can SSRS reports Cache results?

112

What are data resources?

510

Why do we use non clustered index?

556

How is SQL Azure different than SQL server?

Explain how to use linked server?

571

What is normalization? Describe its different types.

592

how you can list all the tables in a database?

528