MSCEWI4061

ALTER COLUMN not supported

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

Severity

Medium

Description

This EWI is added whenever there is an unsupported ALTER COLUMN statement

Code Example

Input Code:

ALTER TABLE
    [Person].[EmailAddress] CHECK CONSTRAINT [FK_EmailAddress_Person_BusinessEntityID]

Output Code:

-- ** MSC-ERROR - MSCEWI4061 - ALTER COLUMN COMMENTED OUT BECAUSE CHECK constraint IS NOT SUPPORTED IN SNOWFLAKE **
--ALTER TABLE
--    [Person].[EmailAddress] CHECK CONSTRAINT [FK_EmailAddress_Person_BusinessEntityID]
-- ** MSC-WARNING - MSCEWI1040 - THE STATEMENT IS NOT SUPPORTED IN SNOWFLAKE **
--GO

Recommendations

Last updated