Links

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.