Basic View

The simplest CREATE VIEW according to the grammar.

Grammar Syntax

Click here to go to the ANSI SQL Standard specification for this syntax.

This syntax is fully supported by Snowflake.

Sample Source Patterns

ANSI SQL Input Code

CREATE VIEW VIEW_NAME1
AS
SELECT
   *
FROM
   SOMETABLE

Snowflake Output Code

CREATE VIEW VIEW_NAME1
AS
SELECT
   *
FROM
   SOMETABLE