MSCEWI4051
Some table elements may have been removed from Add clause.
This EWI was added for an old version of SQL Server SnowConvert
Medium
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.
ALTER TABLE
[Person].[EmailAddress]
ADD
Dummy_Column VARCHAR(32),
CONSTRAINT [DF_EmailAddress_rowguid] DEFAULT 5 FOR [rowguid];
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);
- 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.
Last modified 3mo ago