Links

MSCEWI1080

Default value is not allowed on binary columns

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