COLLATE

Description

Specifies whether string search or comparison on the column is CASE_SENSITIVE or CASE_INSENSITIVE.

Click here to navigate to the Amazon Redshift docs page for this syntax.

Grammar Syntax

COLLATE CASE_SENSITIVE | COLLATE CASE_INSENSITIVE

Sample Source Patterns

Amazon Redshift

Code

CREATE TABLE TABLE1 
(
 COL1 VARCHAR(15),
 COL2 VARCHAR(15) COLLATE CASE_SENSITIVE
);

Snowflake

Code

CREATE TABLE TABLE1
(
 COL1 VARCHAR(15),
 COL2 VARCHAR(15) COLLATE 'cs'
);

Known issues

There are no known issues.