Drop Index

Drop Index

DROP INDEX IX_tblTable01_Col01 ON dbo.tblTable01

Re-create Index

CREATE NONCLUSTERED INDEX [IX_tblTable01_Col01] ON [dbo].[tblTable01]
(
	[Col01] ASC
)
INCLUDE ([Col02]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
GO

Dropping index is fast. Recreating index will take a longer time.