Delphi Database, Delphi Components from ComponentAce
Products Download Order Contact us
DROP INDEX Command
Previous  Top  Next



DROP INDEX allows you to remove an existing index.

Syntax

DROP INDEX [ MEMORY ] table_name.index_name

Description

DROP INDEX removes an index.

MEMORY
If MEMORY keyword is specified before the table_name then an in-memory table is referenced, not a disk one.  

table_name
The name of the table containing index.  

index_name
The name of the index to remove.  

Example:

DROP INDEX developers.idxUniqueName  



        © 2003 - 2017 ComponentAce  | .net zip component | barcode for .net | delphi zip component | delphi database Aug 21, 2017