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

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.

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

• [authorization-identifier.]index-identifier

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.

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.