MSCEWI2012

Binary does not support default.

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]​

MSCEWI2011

MSCEWI2013

Last modified 2mo ago