MSCEWI4050

Valid Default Constraint moved to a new Alter Table Statement.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

This EWI was added for an old version of SQL Server SnowConvert

Severity

Low

Description

This EWI is added when the Default constraint mentioned on MSCEWI1088 is valid and then, transformed to an alter table statement apart.

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

• Visit MSCEWI1088 valid default constraint definition to verify the possible scenarios using that clause.

• If you need more support, you can email us at [email protected]