MSCEWI1080
Default value is not allowed on binary columns
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
Severity
Low
Description
This EWI is added when the source code has a default value for BINARY data type, which is not supported in SnowFlake SQL
Example Code
Input Code:
create table test1345
(
key1 binary default 0
);
Output Code:
CREATE OR REPLACE TABLE PUBLIC.test1345
(
key1 BINARY
-- ** MSC-WARNING - MSCEWI1080 - DEFAULT VALUE IS NOT ALLOWED ON BINARY COLUMNS **
-- default 0
);
Recommendations
If you need more support, you can email us at [email protected]
Last updated