SQL Server Transact Basic to Expert - Drop and recreate an index in a table using Create Index

This blog show how to drop and recreate an index using Create Index command

Example:

CREATE NONCLUSTERED INDEX empind ON
Dbo.emptable (Empid ASC)
WITH (DROP_EXISTING = ON)
GO