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

Karthikeyan Anbarasan
13y
2.8k
0
0

Blog

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

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

Up Next

SQL Server Transact Basic to Expert - To See index metadata

Ebook Download

View all

Introducing Microsoft SQL Server 2016

Read by 11k people

Download Now!

Learn

View all