" /> Password <br /><input type="password" name="passwd" id="passwd" class="inputbox" size="18" alt="password" />
Home SQL Create Index
PDF Note Note

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

- 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:

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

Advertisement