Collate Clause

Collate clause column definition option

Grammar Syntax

<collate clause> ::=
  COLLATE <collation name>

Click here to go to the ANSI SQL Standard specification for this syntax.

This clause is not transformed to Snowflake because there is no sure way to ensure full equivalence.

Sample Source Patterns

ANSI SQL Input Code

CREATE TABLE TABLE01(
    COLNAME VARCHAR(20) COLLATE SOMENAME
);

Snowflake Output Code

CREATE TABLE TABLE01_CHARACTER_STRING_TYPES_CHARACTER_SET (
    COLNAME VARCHAR(20)
-- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE. COLUMN COLLATE **
--                        COLLATE SOMENAME
);

Related EWIs

1. MSCEWI1002: Removed next statement, not applicable in SnowFlake