MSCEWI2012

Binary does not support default.

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

Severity

Low

Description

This message is shown when SnowConvert finds a data type BINARY along with a DEFAULT value specification. Since default values are not allowed in BINARY columns, it is removed and a warning is added.

Code Example

Input Code:

CREATE TABLE TableExample
(
ColumnExample BINARY DEFAULT '00000000'XB NOT NULL
)

Output Code:

CREATE TABLE PUBLIC.TableExample
(
ColumnExample BINARY NOT NULL /*** MSC-WARNING - MSCEWI2012 - BINARY DOES NOT SUPPORT DEFAULT '00000000'XB ***/
);

Recommendations

• No additional user actions are required.

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