DROP ALIAS (Delete alias)
Function
DROP ALIAS deletes a table alias that was created to permit access to tables that exist in other RD nodes.
Privileges
- Owners of the table alias
- This owner can delete his or her own table alias.
- Users with DBA privilege
- These owners can delete table aliases belonging to other users.
Format
DROP ALIAS [authorization-identifier.] table-alias
Operands
- [authorization-identifier.] table-alias
- authorization-identifier
- Specifies the authorization identifier of the user who owns the table alias being deleted. The default is the authorization identifier of the user who is executing the DROP ALIAS function.
- table-alias
- Specifies the table alias to be deleted.
Common rules
- Deleting an alias of a table does not cause the table itself to be deleted.
- Deleting the schema for a table alias does not delete the table alias.
- Deleting the table for which an alias is defined does not delete the table alias.
- Revoking the schema privilege of the owner of a table alias does not delete the table alias.
Notes
- The DROP ALIAS statement cannot be specified from an X/Open-compliant UAP running under OLTP.
Example
Delete table alias ALS1 defined on a table with RD node name NOD1, authorization identifier USR1, and table identifier TBL1:
DROP ALIAS