Skip to main content
Skip table of contents

Alter View

Usage

SQL
ALTER VIEW name[column_name column_type, ..., PRIMARY KEY(column_name)] AS queryExpression

Syntax Rules

  • The ALTER query expression may be prefixed with a cache hint for materialized view definitions. The hint will take effect the next time the materialized view table is loaded;
  • PRIMARY KEY, which uniquely identifies each record in a table, must contain a unique value and cannot be null;
  • The number of columns in queryExpression must not be changed.

Example

SQL
CREATE VIEW views.creditcard AS SELECT * FROM adventureworks.creditcard;

ALTER VIEW views.creditcard AS SELECT * from (SELECT * FROM adventureworks.creditcard) a;

ALTER VIEW views.creditcard(a integer, b integer, PRIMARY KEY(a)) AS SELECT * FROM adventureworks.creditcard;
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.