One table can only one clustered index or primary key and 249 non-clustere

How many index keys possible for a table

Question Posted / anand k

Answer Posted / anand k

One table can only one clustered index or primary key and
249 non-clustered index or unique key

Is This Answer Correct ?

10 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How can a database be repaired?

934

Does partitioning improve performance sql server?

916

Explain different types of Normalization.

1758

How would you add a section to a table?

984

What is dbcc? Give few examples.

967

What is a trigger and types of a trigger?

942

What are the functions in sql server?

917

Can you move the resources after pausing the node? : sql server database administration

1049

What is user-defined inline table-valued function?

912

How to handle error or exception in sql?

952

How to view existing indexes on an given table using sys.indexes?

1047

What is the significance of null value and why should we avoid permitting null values?

937

What is filter index?

914

How to enable/disable indexes?

1024

how to overcome kernel isssues

1583