Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
CREATE TABLE statementUse the CREATE TABLE statement to create a new permanent table in the current database.
OF TYPE ClauseUse the OF TYPE clause to create a typed table for an object-relational database. A typed table is a table in which every row is an object of the named ROW data type that you specify in this clause.
Using the UNDER Clause
Restrictions on Table Hierarchies

Restrictions on Table Hierarchies

Inheritance occurs in one direction only, namely from supertable to subtable. Properties of subtables are not inherited by supertables. The section System Catalog Information lists the inherited database objects for which the system catalog maintains no information regarding subtables.

No two tables in a table hierarchy can have the same data type. For example, the final line of the next code example is invalid, because the tables tab2 and tab3 cannot have the same row type (rowtype2):

         create row type rowtype1 (...);
         create row type rowtype2 (...) under rowtype1;
         create table tab1 of type rowtype1;
         create table tab2 of type rowtype2 under tab1;
         create table tab3 of type rowtype2 under tab1; -- This is not valid.