4D v16

DROP INDEX

Home

 
4D v16
DROP INDEX

DROP INDEX  


 

 

 DROP INDEX sql_name

The DROP INDEX command is used to remove an existing index named sql_name from a database. It cannot be used on indexes created for PRIMARY KEY or UNIQUE constraints.

Example  

Here is a simple example for removing an index:

DROP INDEX ID_INDEX



See also 

CREATE INDEX

 
PROPERTIES 

Product: 4D
Theme: SQL Commands

 
HISTORY 

 
ARTICLE USAGE

4D SQL Reference ( 4D v16)