UNIQUE | PRIMARY KEY

UNIQUE

Description

Specifies that the column can contain only unique values.

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

Grammar Syntax

UNIQUE

Sample Source Patterns

Amazon Redshift

Code

CREATE TABLE TABLE1 
(
 COL1 VARCHAR(15),
 COL2 VARCHAR(15) UNIQUE
);

Snowflake

Code

CREATE TABLE TABLE1
(
 COL1 VARCHAR(15),
 COL2 VARCHAR(15) UNIQUE
);

Primary Key

Description

Specifies that the column is the primary key for the table.

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

Grammar Syntax

PRIMARY KEY

Sample Source Patterns

Amazon Redshift

Code

CREATE TABLE TABLE1 
(
 COL1 VARCHAR(15) PRIMARY KEY,
 COL2 VARCHAR(15)
);

Snowflake

Code

CREATE TABLE TABLE1
(
 COL1 VARCHAR(15) PRIMARY KEY,
 COL2 VARCHAR(15)
);

Known issues

There are no known issues.