Syntax: 

DROP INDEX [ IF EXISTS ] [catalog-name.]index-name    
	

The DROP INDEX statement removes an index which has been created with the CREATE INDEX command. The index named index-name is completely removed from the database. The only way to recover the index is to reenter the appropriate CREATE INDEX command.

The DROP INDEX statement does not reduce the size of the database file. Empty space in the database is retained for later INSERT commands.