As Select

Specifies that the columns of the View have the same name, data type as the result from the select.

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
(
   COL1,
   COL2
)
AS
SELECT  
   *
FROM  
   SOMETABLE

Snowflake Output Code

CREATE VIEW VIEW_NAME1
(
   COL1,
   COL2
)
AS
SELECT  
   *
FROM  
   SOMETABLE