To remove index from table we use drop index statement in sql server.
Thank you for reading this post, don't forget to subscribe!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