Links

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 en 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.
  • 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.