Home SQL Create Index
E-mail Print PDF

CREATE INDEX - This query is used to create indexes on the table.

Note - Note:

SQL CREATE INDEX syntax

CREATE INDEX index_name
ON table_name (column_name)

Syntax SQL CREATE UNIQUE INDEX

CREATE UNIQUE INDEX index_name
ON table_name (column_name)

Note - Note:

Example of CREATE INDEX

1
2
CREATE INDEX PIndex
ON Persons (LastName)

1
2
CREATE INDEX PIndex
ON Persons (LastName, FirstName)

Authorization

Nice Ajax Poll

Which one of my extensions is the best?

Statistics

Translate

русскийitalianoDeutschEnglishLATVIANукраїнськаfrançaispolski
1

Advertisement