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

MSCEWI4050

MSCEWI4052

Last modified 3mo ago