Comment on page
MSCEWI1093
On Commit not supported
Medium
The clauses On Commit specified in a Create Table can only be used in temporal tables. If a non-temporal table has a commit, it will be commented. Also, Snowflake does not support the ON COMMIT DELETE, so it will be commented as well.
CREATE TABLE TABLE01 (COLNAME VARCHAR(20)) ON COMMIT PRESERVE ROWS
CREATE TEMPORARY TABLE TABLE01 (COLNAME VARCHAR(20)) ON COMMIT DELETE ROWS
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
- No additional user actions are required.