PRIMARY KEY
Description
Specifies that a column or a number of columns of a table can contain only unique non-null values
Click here to navigate to the Amazon Redshift docs page for this syntax.
Grammar Syntax
PRIMARY KEY ( column_name [, ... ] )
Sample Source Patterns
Amazon Redshift
CREATE TABLE TABLE1
(
COL1 VARCHAR(15),
COL2 VARCHAR(15),
PRIMARY KEY (COL1,COL2)
);
Snowflake
CREATE TABLE TABLE1
(
COL1 VARCHAR(15),
COL2 VARCHAR(15),
PRIMARY KEY (COL1,COL2)
);
Known issues
There are no known issues.
Last updated
Was this helpful?