Check Constraint

Description

Constraints are used to specify rules for the data in a table.

Click here to navigate to the IBM DB2 docs page for this syntax.

Some CONSTRAINT options are migrated as is to Snowflake but some of them are removed because of platform differences. Check the code example to learn more.

Grammar Syntax

Sample Source Patterns

IBM DB2

Code

CREATE TABLE T1(
    COL1 VARCHAR(1),
    CONSTRAINT CN1 CHECK(COL1<1),
    CONSTRAINT CN2 CHECK(SOMENAME DETERMINED BY OTHERNAME), 
    CONSTRAINT CN2 CHECK((SOMENAME1, SOMENAME2) DETERMINED BY (SOMENAME3, SOMENAME4))
    );

Snowflake

Code

CREATE OR REPLACE TABLE PUBLIC.T1 (
COL1 VARCHAR(1)
--    /--*** MSC-WARNING - MSCEWI1035 - CHECK STATEMENT NOT SUPPORTED ***--/
--    CONSTRAINT CN1 CHECK(COL1<1)
--    /--*** MSC-WARNING - MSCEWI1035 - CHECK STATEMENT NOT SUPPORTED ***--/
--    CONSTRAINT CN2 CHECK(SOMENAME DETERMINED BY OTHERNAME)
--    /--*** MSC-WARNING - MSCEWI1035 - CHECK STATEMENT NOT SUPPORTED ***--/
--    CONSTRAINT CN2 CHECK((SOMENAME1, SOMENAME2) DETERMINED BY (SOMENAME3, SOMENAME4))
);

Related EWIs

1. MSCEWI1073: Check Statement Not Supported.