Back

Explore Courses Blog Tutorials Interview Questions

How many non-clustered index in SQL Server?

0 votes
2 views
in SQL by (45k points)
Could someone tell me how many non-clustered indexes could be created in sql server?

1 Answer

0 votes
by (99k points)

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.

Related questions

0 votes
4 answers
How many types of constraints are present in SQL Server?
asked Mar 23, 2021 in SQL by dev_sk2311 (45k points)
0 votes
1 answer
How to create a table from select query result in SQL Server 2008
asked Jan 2, 2021 in SQL by Appu (6.1k points)
0 votes
1 answer
How to execute function in SQL Server 2008
asked Dec 30, 2020 in SQL by Appu (6.1k points)

Browse Categories

© COPYRIGHT 2011-2023 INTELLIPAAT.COM. ALL RIGHTS RESERVED.

Download Salary Trends Now !

Learn how professionals like you got up to 100% Salary Hike.

...