Create and Delete INDEX in SQL Server

Drop index from table :

DROP INDEX table_name.index_name

DROP INDEX aspnet_Paths.aspnet_Paths_index

Create Index in table:

CREATE INDEX aspnet_Paths_index
ON aspnet_Paths (PathID)