Altering a view

Authorities and privileges

To alter a view:

1. Open the Alter View window.
2. The following fields are read-only:
• You can see the existing schema name in the View schema field.
• You can see the existing name of the view in the View name field.
• View the contents of the SQL statement box to see how the view was generated.
• The selected radio button indicates the options that were created with the view.

3. In the Comment field, type any comments you want to include with the view. This adds a COMMENT ON statement which adds comments in the description of the view in the REMARKS column of the catalog table for the row that describes the view. The maximum number of characters is 254.
4. Click OK to save your changes and close the window.

View owners and privileges

About granting and revoking privileges