UNIQUE

Description

Specifies that a group of one or more columns of a table can contain only unique values.

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

Grammar Syntax

UNIQUE ( column_name [, ... ] )

Sample Source Patterns

Amazon Redshift

Code

CREATE TABLE TABLE1 
(
 COL1 INT,
 COL2 INT,
 COL3 INT
 UNIQUE (COL1, COL3)
);

Snowflake

Code

CREATE TABLE TABLE1
(
 COL1 INT,
 COL2 INT,
 COL3 INT,
 UNIQUE (COL1, COL3)
);

Known issues

There are no known issues.