User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

To replace a view definition with a modified version. You must include the entire new view definition in the ALTER VIEW statement, and reassign permissions on the view

Syntax

     ALTER VIEW
          ... [ owner.]view-name [( column-name, ... )]
          ... AS select-without-order-by
          ... [ WITH CHECK OPTION ]

Usage

Anywhere.

Permissions

Must be owner of the view or have DBA authority.

Side effects

Automatic commit.

See also

• CREATE VIEW statement
• DROP statement

Description

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 and CREATE VIEW were carried out, permissions on the view would have to be reassigned.