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.]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.
Notes
- DROP FOREIGN INDEX cannot delete indexes on the foreign server side.
- DROP FOREIGN INDEX cannot be specified from an X/Open compliant UAP running under OLTP.