CodesJava

Easy learning with example program codes

SQL INDEX Constraint


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:
Posted in SQL   


Copyright © 2019 CodesJava DMCA.com Protection Status SiteMap Reference: Java Wiki