SQL INDEX Constraint

by

The INDEX is used to create and retrieve data from the table very quickly. An INDEX is created with CREATE INDEX statement.
Syntax: 

CREATE INDEX indexName ON tableName (column1, column2.....); 

Drop an INDEX Constraint:

Use the following syntax to drop an index constraint.

ALTER TABLE tableName DROP INDEX indexName;

 
Next Topic: SQL INSERT statement with example.
Previous Topic: SQL UNIQUE Constraint with example.