DEFAULT

Description

Assigns a default data value for the column.

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

Grammar Syntax

DEFAULT default_expr

Sample Source Patterns

Amazon Redshift

Code

CREATE TABLE TABLE1 
(
 COL1 VARCHAR(15) DEFAULT 'default_value',
 COL2 VARCHAR(15)
);

Snowflake

Code

CREATE TABLE TABLE1
(
 COL1 VARCHAR(15) DEFAULT 'default_value',
 COL2 VARCHAR(15)
);

Known issues

There are no known issues.