Creating a view
Use the Create View window to create a view on tables or other views on
the current server.
Authorities
and privileges
To create a view:
-
Open the Create View window.
-
In the View schema field, type a 1-8 character name that is unique
on the current server. You can use an existing schema name, or a new one.
-
In the View name field, type a 1-8 character name that is unique.
-
Edit the contents of the SLQ statement box to enter the values that you
want for the COLUMN,
AS, WITH,
SELECT, FROM, and WHERE clauses.
-
Select a radio button to indicate whether you want check option None,
Cascaded,
or Local.
-
Optional: In the Comments field, type any comments about the view.
-
Click OK to save your changes and close the window.
Related information
View owners and privileges
About granting and revoking
privileges