How to remove (Drop) index from table in SQL Server?

Introduction:

We can add and remove Indexes on table in sql server. Indexes can be added and drop by using query in SQL server.

in this  I will explain how to remove index from table in sql server 2008 or drop index from table in sql server. To remove index from table we use drop index statement in sql server.

To create index on column in sql server that syntax will be like as shown below

Syntax to Create Index

CREATE INDEX indexname ON Tablename(columnname)

Example:

CREATE INDEX IC_Userid ON UserDetails(UserId)

Remove index on table

Syntax to Drop Index on Column

DROP INDEX tablename.indexname

Example:

DROP INDEX UserDetails.IC_Userid