How many index keys possible for a table

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do we Backup SQL Azure Data?

98


What is apply operator in sql?

757


What happens if null values are involved in string operations?

715


What are indexers?

804


When a primary key constraint is included in a table, what other constraints does this imply?

761






What are the types of table?

731


What is the openxml statement in sql server?

723


What is implicit cursors?

743


Do you know what are different types of replication in sql server?

734


Which database stores information about replication?

725


what is database replication? : Sql server database administration

711


What are the filtered indexes?

776


How to use column default values in insert statements in ms sql server?

714


What is the difference between a function and a stored procedure?

750


You want to use a perspective in an mdx query. How do you select the perspective?

185