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.
Please follow and like us: