Of Type

Description

Specifies that the columns of the table are based on the attributes of the structured type.

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

TYPED TABLES are not supported in Snowflake.

Grammar Syntax

Sample Source Patterns

IBM DB2

Code 1

   CREATE TABLE Student OF Student_t UNDER Person
   INHERIT SELECT PRIVILEGES;

Snowflake

Code 1

-- ** MSC-ERROR - MSCEWI1021 - TYPED TABLES ARE NOT SUPPORTED **
--   CREATE TABLE Student OF Student_t UNDER Person
--      INHERIT SELECT PRIVILEGES

Related EWIs

1. MSCEWI1021: NODE NOT SUPPORTED