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
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

  1. Deleting an alias of a table does not cause the table itself to be deleted.
  2. Deleting the schema for a table alias does not delete the table alias.
  3. Deleting the table for which an alias is defined does not delete the table alias.
  4. Revoking the schema privilege of the owner of a table alias does not delete the table alias.

Notes

  1. 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