MSCEWI4002
Constraint in default expression not supported.
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
This EWI is deprecated, for more information on this issue referred to MSCEWI1097
Severity
Low
Description
This warning is added when there is a Constraint constraintName used in a default expression of a Column Definition. Since Constraint constraintName is not supported en Snowflake, it is removed and a warning is added.
Code Example
Input Code:
CREATE TABLE [SCHEMA1].[TABLE1] (
[COL1] VARCHAR (10) CONSTRAINT [constraintName] DEFAULT ('0') NOT NULL
);
Output Code:
CREATE TABLE "SCHEMA1"."TABLE1" (
"COL1" VARCHAR (10) /*** MSC-WARNING - MSCEWI4002 - CONSTRAINT IN DEFAULT EXPRESSION NOT SUPPORTED ***/
DEFAULT ('0') NOT NULL
);
Recommendations
No additional user actions are required.
If you need more support, you can email us at [email protected]
Last updated