• September 29, 2014
  • SQL
  • Comments Off on SQL INDEX Constraint

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.

Related Topics:

How to build java project using ant in eclipse?
JAXB marshalling – convert java object to xml example.
How to create pdf file in java using iText jar?
Generics class example.
OGNL in struts 2.
Hibernate One-to-One Mapping using xml.
Send inline image in email using JavaMail API.
Quartz 2 JobListener example.

 


Comments are closed.