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 to create user messages with print statements in ms sql server?

588


How do you Implement SSIS Packages in your Project?

1508


What are the types of indexing?

592


Can you explain the disadvantages/limitation of the cursor?

500


How to create a view using data from another view?

561






Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

574


Explain system functions or built-in functions? What are different types of system functions?

558


What does it mean to normalize a database and why would you do it?

521


What command do we use to rename a db, a table and a column?

497


What are ddl triggers and types of ddl trigger?

600


Explain the xml support sql server extends?

611


How data can be copied from one table to another table?

507


Define Joins?

605


What are the types of subquery?

546


What is the difference between writing data to mirrored drives versus raid5 drives

504