Altering a view
Use the Alter View window to add or modify the comment on a view.
Authorities
and privileges
To alter a view:
-
Open the Alter View window.
-
The following fields are read-only:
You can see the existing owner name or authorization
ID in the View owner 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.
-
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.
-
Click OK to save your changes and close the window.
Related information
View owners and privileges
About granting and revoking
privileges