Mega Code Archive

 

Categories / MSSQL Tutorial / Index

 

The basic syntax of the CREATE INDEX statement

CREATE [CLUSTERED|NONCLUSTERED] INDEX index_name     ON table_name (column_name_1 [ASC|DESC] [,  column_name_2 [ASC|DESC]]...)