Recursive Clause

Optional Recursive clause

The optional recursive clause specifies that the view can refer to itself using recursive syntax without necessarily using a CTE (common table expression).

Grammar Syntax

CREATE [ RECURSIVE ] VIEW <table name>  <view specification> 
      AS <query expression> 

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 RECURSIVE VIEW VIEW_NAME
AS
SELECT
   *
FROM
   SOMETABLE;

Snowflake Output Code

CREATE RECURSIVE VIEW PUBLIC.VIEW_NAME
AS
SELECT
   *
FROM
   PUBLIC.SOMETABLE;