MSCEWI4002

Constraint in default expression not supported.

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.
For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.

MSCEWI4001

MSCEWI4003

Last modified 6mo ago