DROP FOREIGN INDEX (Delete a foreign index)

Function

Deletes the definition of a foreign index without deleting indexes on the foreign server side.

Privileges

Owner of a foreign index
This user can delete the definition of his or her own index.
Users with the DBA privilege
These users can delete the definitions of foreign indexes owned by other users.

Format

DROP FOREIGN INDEX [authorization-identifier.]index-identifier

Operands

authorization-identifier
Specifies the authorization identifier of the owner of the foreign index to be deleted. The default is the authorization identifier of the user who is issuing DROP FOREIGN INDEX.
index-identifier
Specifies the name of the foreign index to be deleted.

Notes

  1. DROP FOREIGN INDEX cannot delete indexes on the foreign server side.
  2. DROP FOREIGN INDEX cannot be specified from an X/Open compliant UAP running under OLTP.