Blog

CREATE AND DROP NONCLUSTERED INDEX (MSSQL)

|use DataBase
|
|IF EXISTS (SELECT * FROM sys.indexes WHERE name='name_index') drop index table.name_index
|
|CREATE NONCLUSTERED INDEX name_index ON table (column_name)
|";

Tested on MSSQL 2008R2

Read 1400 times
Rate this item
(0 votes)

Leave a comment

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.

Счетчики

Gallery

Киев, Новозабарская, 2/6

+38(044)361-0274        +38(044)383-7364