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

What do you do in data exploration

994

Comment,Datatypes are unlimited

2060

What is database replication?

1144

How many tables can be joined in SQL Server?

1065

Explain how would you store your query in an SSRS report or a Database server?

128

What are the different type of replication in sql server?

981

what are user defined datatypes? : Sql server database administration

967

What is the main purpose of having conversation group?

900

Describe the left outer join & right outer join. : sql server database administration

997

How can I track the changes or identify the latest insert-update-delete from a table?

964

What is default constraint?

1000

How to select some specific rows from a table in ms sql server?

1008

What are locks in sql?

985

Explain how many types of relationship?

1030

Name and describe few console utilities for ssrs?

284