GENERATED BY DEFAULT AS IDENTITY

Description

Specifies that the column is a default IDENTITY column and enables you to automatically assign a unique value to the column.

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

Grammar Syntax

GENERATED BY DEFAULT AS IDENTITY ( seed, step )

Sample Source Patterns

Amazon Redshift

Code

CREATE TABLE TABLE1 
(
 COL1 INT GENERATED BY DEFAULT AS IDENTITY ( 100, 1 ),
 COL2 VARCHAR(15)
);

Snowflake

Code

CREATE OR REPLACE SEQUENCE TABLE1_COL1
COMMENT = 'FOR TABLE-COLUMN TABLE1.COL1';
CREATE OR REPLACE TABLE TABLE1 (
 COL1 INT DEFAULT TABLE1_COL1.NEXTVAL /*** MSC-WARNING - MSCEWI1048 - SEQUENCE -  GENERATED BY DEFAULT  100, 1 ***/ ,
 COL2 VARCHAR(15)
);

Related EWIs

MSCEWI1048: Sequence warning