SCOPE

Description

Identifies the scope of the reference type column.

Click here to navigate to the IBM DB2 docs page for this syntax.

SCOPE options are removed because they are not applicable in Snowflake.

Grammar Syntax

Sample Source Patterns

IBM DB2

Code

CREATE TABLE T1
(
COL1 VARCHAR(10) SCOPE TABLE2,
COL2 VARCHAR(10) SCOPE VIEW1
)

Snowflake

Code

CREATE TABLE T1
(
COL1 VARCHAR(10) -- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE.  **
--  SCOPE TABLE2
,
COL2 VARCHAR(10)-- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE.  **
--  SCOPE VIEW1
)

Known issues

There are no known issues.