FOREIGN KEY

Description

Constraint that specifies a foreign key constraint, which requires that a group of one or more columns of the new table must only contain values that match values in the referenced column or columns of some row of the referenced table.

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

Grammar Syntax

FOREIGN KEY (column_name [, ... ] ) REFERENCES reftable [ ( refcolumn )

Sample Source Patterns

RedShift Input Code:

IN -> Redshift_01.sql

CREATE TABLE table15 (
    col1 INTEGER,
    FOREIGN KEY (col1) REFERENCES table_test (col1)
);

Snowflake Output Code:

OUT -> Redshift_01.sql

CREATE TABLE table15 (
    col1 INTEGER,
    FOREIGN KEY (col1) REFERENCES table_test (col1)
)
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "redshift",  "convertedOn": "09/17/2024" }}'
;

Related EWIs

There are no known issues.