In this step by step SQL Tutorial I will show you how to remove Index from database. For the purpose of this tutorial I will use SQL Server 2012.
Other Versions of SQL Server:
- SQL Server 2012
- This blog post has been written using SQL Server 2012
Who is it for?
- People who would like to learn basics of using DROP INDEX.
- Those who are preparing for Microsoft certifications and need to cover this topic.
SQL DROP INDEX is used to remove Index from database.
Below I show you how to remove Index from database table using SSMS interface and using T-SQL.
In the Object Explorer I open required database in this case it is AdventureWorksDW2012 then I open table from which we want to remove Index. In this example it is table dbo.DimCustomer, Index called Test.
To get full access to this page
Become a member or Sign in
Membership is just $3.99/month