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
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 and commented out to avoid compilation problems.
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],
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 ***/
;
- If there are no valid table elements in the
default
clause, thealter table
will be totally commented out.
Last modified 1mo ago