Altering an alias

Use the Alter Alias window to add, change, or delete a comment on an alias for a table or view.

Attention: You cannot change the alias itself. However, you can create a new one and use it in place of the old one. Optionally, you can also drop the old one.

Fields and controls

Authorities and privileges

To add, change, or delete a comment on an alias:

1. Open the Alter Alias window.

2. Fill in, update, or clear the Comment field.

3. Click on OK to commit your change.

Related information

• COMMENT ON statement -- See the SQL Reference
• Creating a table or view alias
• Dropping a table or view alias
• More about table and view aliases -- See "Creating an Alias" in the Administration Guide .
• Database aliases
• Showing Commands or SQL