On Commit

Commit by action

Grammar Syntax

<ON COMMIT <table commit action>  ROWS

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

On Commit is supported only in temporal tables.

ON COMMIT DELETE ROWS is not supported.

Sample Source Patterns

ANSI SQL Input Code

CREATE TABLE TABLE01 (COLNAME VARCHAR(20)) ON COMMIT PRESERVE ROWS;
CREATE TEMPORARY TABLE TABLE01 (COLNAME VARCHAR(20)) ON COMMIT DELETE ROWS;
CREATE TEMPORARY TABLE TABLE01 (COLNAME VARCHAR(20)) ON COMMIT PRESERVE ROWS;

Snowflake Output Code

CREATE TABLE TABLE01 (COLNAME VARCHAR(20))
-- ** MSC-ERROR - MSCEWI1093 - ON COMMIT NOT SUPPORTED **
--                                           ON COMMIT PRESERVE ROWS
CREATE TEMPORARY TABLE TABLE01 (COLNAME VARCHAR(20))
-- ** MSC-ERROR - MSCEWI1093 - ON COMMIT NOT SUPPORTED **
--                                                     ON COMMIT DELETE ROWS
CREATE TEMPORARY TABLE TABLE01 (COLNAME VARCHAR(20)) ON COMMIT PRESERVE ROWS

Related EWIs

1. MSCEWI1093: On Commit not supported.