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 is a group function explain with an example?

979

How to create an identity column?

1202

What is database isolation in sql server? : sql server database administration

1096

explain declarative management framework (dmf) in sql server 2008?

983

Write a code to select distinct records without using the DISTINCT keyword.

1108

what types of replication are supported in sql server? : Sql server database administration

1034

What do you know about system database? : SQL Server Architecture

978

how can a database be repaired? : Sql server administration

965

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1019

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1881

Define self join?

1022

What are the advantages of user defined function?

979

How would you use user_constraints table in DB?

1001

What is xdr?

983

What is the difference between TRUNCATE and DROP?

1128