ENFORCED

Description

Specifies whether the constraint is enforced by the database manager during normal operations such as insert, update, or delete.

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

TRUSTED Constraint attributes are removed because they are not applicable in Snowflake.

Grammar Syntax

Sample Source Patterns

IBM DB2

Code

CREATE TABLE T1
(
COL1 VARCHAR(10),
COL2 VARCHAR(10),
CONSTRAINT ConstraintName UNIQUE (COL1, COL2) NOT ENFORCED NOT NULL
);

Snowflake

Code

CREATE TABLE T1
(
COL1 VARCHAR(10),
COL2 VARCHAR(10),
CONSTRAINT ConstraintName UNIQUE (COL1, COL2)NOT ENFORCED
-- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE.  **
--                                                NOT NULL
);

Known issues

There are no known issues.