MSCEWI4051

Some table elements may have been removed from Add clause.

This EWI was added for an old version of SQL Server SnowConvert

Severity

Medium

Description

This EWI is added when different table elements do not have a functional equivalence in Snowflake or have a transformation planned. A new Alter Table statement is generated if there are functional table elements.

Code Example

Input Code:

ALTER TABLE
    [Person].[EmailAddress]
ADD
    Dummy_Column VARCHAR(32),
    CONSTRAINT [DF_EmailAddress_rowguid] DEFAULT 5 FOR [rowguid];
    

Output Code:

ALTER TABLE
Person.EmailAddress
ALTER rowguid SET DEFAULT 5;


/*** MSC-ERROR - MSCEWI4050 - DEFAULT CONSTRAINT MOVED TO A NEW ALTER TABLE STATEMENT ***/
ALTER TABLE
    Person.EmailAddress
ADD
    Dummy_Column VARCHAR(32);

Recommendations

  • If there are no valid table elements into the default clause, the alter table will be totally commented.

  • If you need more support, you can email us at snowconvert-support@snowflake.com

Last updated