How many non-clustered index in SQL Server?

Question

Could someone tell me how many non-clustered indexes could be created in sql server?

Answer 1

Within SQL Server, you could create a maximum of 999 non-clustered indexes per table. These numbers do not include XML indexes. If you are interested in learning SQL and wish to get certified and trained in SQL, then check out the SQL training course from Intellipaat. Also, watch our YouTube video on SQL Tutorial For Beginners to get your fundamentals correct.