4D v14

DROP INDEX

Home

 
4D v14
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

 
PROPERTIES 

Product: 4D
Theme: SQL Commands

 
SEE ALSO 

CREATE INDEX

 
ARTICLE USAGE

4D SQL Reference ( 4D v11 SQL Release 4 )
4D SQL Reference ( 4D v14)
4D SQL Reference ( 4D v12.1)
4D SQL Reference ( 4D v13.4)
4D SQL Reference ( 4D v14 R2)
4D SQL Reference ( 4D v14 R3)
4D SQL Reference ( 4D v14 R4)