Export (0) Print
Expand All

CREATE VIEW Statement (Microsoft Access SQL)

Office 2007

Creates a new view.

Bb177895.vs_note(en-us,office.12).gif  Note
The Microsoft Access database engine does not support the use of CREATE VIEW, or any of the DDL statements, with non-Microsoft Access database engine databases.
Syntax

CREATE VIEW view [(field1[, field2[, …]])] AS selectstatement

The CREATE VIEW statement has these parts:

PartDescription
viewThe name of the view to be created.
field1, field2The name of field or fields for the corresponding fields specified in selectstatement.
selectstatementA SQL SELECT statement. For more information, see SELECT Statement.
Remarks

The SELECT statement that defines the view cannot be a SELECT INTO statement.

The SELECT statement that defines the view cannot contain any parameters.

The name of the view cannot be the same as the name of an existing table.

If the query defined by the SELECT statement is updatable, then the view is also updatable. Otherwise, the view is read-only.

If any two fields in the query defined by the SELECT statement have the same name, the view definition must include a field list specifying unique names for each of the fields in the query.

See Also

ADD USER Statement

ALTER TABLE Statement

ALTER USER or DATABASE Statement

CONSTRAINT Clause

CREATE INDEX Statement

CREATE PROCEDURE Statement

CREATE TABLE Statement

CREATE USER or GROUP Statement

DROP Statement

DROP USER or GROUP Statement

GRANT Statement

REVOKE Statement



Community Additions

ADD
Show:
© 2015 Microsoft