Chapter 9 SQL Statements
399
ALTER VIEW statement
Use this statement to replace a view definition with a modified version. You
must include the entire new view definition in the ALTER VIEW statement.
ALTER VIEW
… [
owner
.]
view-name
[(
column-name
, … )]
… AS
select-without
-
order-by
… [ WITH CHECK OPTION ]
Must be owner of the view or have DBA authority.
Automatic commit.
All procedures and triggers are unloaded from memory, so that any
procedure or trigger that references the view reflects the new view definition.
The unloading and loading of procedures and triggers can have a
performance impact if you are regularly altering views.
"CREATE VIEW statement" on page 482
"DROP statement" on page 505
The ALTER VIEW statement is identical in syntax to the CREATE VIEW
statement except for the first word. The ALTER VIEW statement replaces
the entire contents of the CREATE VIEW statement with the contents of the
ALTER VIEW statement. Existing permissions on the view are maintained,
and do not have to be reassigned. If a DROP VIEW followed by a CREATE
VIEW is used, instead of ALTER VIEW, permissions on the view would
have to be reassigned.
$ For information on the keywords and options, see "CREATE VIEW
statement" on page 482.
♦
SQL/92 Vendor extension
♦
Sybase Not supported by Adaptive Server Enterprise.
Function
Syntax
Permissions
Side effects
See also
Description
Standards and
compatibility
To Next Page
Loading...