With System Versioning

A system-versioned temporal table is a type of user table designed to keep a full history of data changes, allowing easy point-in-time analysis.

Grammar Syntax

WITH <system versioning clause>  

<system versioning clause> ::=   SYSTEM VERSIONING

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

WITH SYSTEM VERSIONING is not supported.

Sample Source Patterns

ANSI SQL Input Code

CREATE TABLE T1 (COL1 VARCHAR) WITH SYSTEM VERSIONING

Snowflake Output Code

CREATE TABLE T1 (COL1 VARCHAR)
-- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE. WITH SYSTEM VERSIONING **
--                               WITH SYSTEM VERSIONING

Related EWIs

1. MSCEWI1002: Removed next statement, not applicable in SnowFlake.