MSCEWI4051
Some table elements may have been removed from Add clause.
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
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 [email protected]
Last updated