Links

MSCEWI4052

Some functional table elements may have been reordered to a new Alter Table statement.
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 and commented out to avoid compilation problems.

Code Example

Input Code:

ALTER TABLE
[Person].[EmailAddress]
ADD
Dummy_Column VARCHAR(32),
Another_Column datetime2 GENERATED ALWAYS AS ROW START HIDDEN NOT NULL DEFAULT SYSUTCDATETIME()
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);
/*** MSC-WARNING - MSCEWI4051 - INVALID TABLE ELEMENTS WERE REORDERED ***/
--ALTER TABLE
-- Person.EmailAddress
--ADD
-- Another_Column datetime2 GENERATED ALWAYS AS ROW START HIDDEN NOT NULL DEFAULT SYSUTCDATETIME() /*** MSC-ERROR - MSCEWI1031 - SYSUTCDATETIME FUNCTION NOT SUPPORTED ***/
;

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.