Home > SQL > Creating an Index

SQL Syntax Creating an Index

Creating an Index Examples

CREATE CLUSTERED INDEX Index_Name_Clstd ON Country(CapitalCity);
CREATE NONCLUSTERED INDEX Index_Name_NonClstd ON Country(CapitalCity);

See also SQL syntax for:

CREATE TABLE
Renaming a View
ALTER TABLE
AVG
Deleting an Index

Terms and Conditions