Drop index from Table

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 IM_Userid ON UserMaster(UserId)
If you want to remove index on table we need to write the query like as shown below

Syntax to Drop Index on Column

DROP INDEX tablename.indexname
Example:

DROP INDEX UserMaster.IM_Userid