FirebirdSQL logo
 TABLEVIEW 

Who Can Drop an Index?

The DROP INDEX statement can be executed by:

  • Administrators

  • The owner of the table

  • Users with the ALTER ANY TABLE privilege

DROP INDEX Example

Dropping the IDX_UPDATER index
DROP INDEX IDX_UPDATER;
See also

[fblangref50-ddl-idx-create], [fblangref50-ddl-idx-altridx]