Comment on page

MSCEWI1097

Constraint in default expression is not supported.

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 in Snowflake, it is removed and a warning is added.
Code Example
Input Code:
CREATE TABLE TABLE1 ( 
COL1 VARCHAR (10) CONSTRAINT constraintName DEFAULT ('0') NOT NULL 
);
Output Code:
CREATE TABLE T1 (
COL1 VARCHAR (10)
/*** MSC-WARNING - MSCEWI1097 - CONSTRAINT IN DEFAULT EXPRESSION IS NOT SUPPORTED IN SNOWFLAKE ***/
DEFAULT ('0') NOT NULL)
Recommendations
No end-user action is required.
If you need more support, you can email us at [email protected]​

MSCEWI1096

MSCEWI1098

Last modified 1mo ago