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.
System Catalog Information

System Catalog Information

When you create a table, the database server adds information about the table to the systables system catalog table, and column information to syscolumns system catalog table. The sysfragments system catalog table contains information about fragmentation strategies and the storage location of fragments. The sysblobs system catalog table contains information about the location of dbspaces and of simple large objects. (The syschunks table in the sysmaster database contains information about the location of smart large objects.)

The systabauth, syscolauth, sysfragauth, sysprocauth, sysusers, and sysxtdtypeauth tables contain information about the discretionary access privileges that various CREATE TABLE options require.

The sysextcols, sysextdfiles, and sysexternal tables contain additional information about objects that the CREATE EXTERNAL TABLE statement registers in the database.

The systables, sysxtdtypes, and sysinherits system catalog tables provide information about typed tables. For typed-table hierarchies, constraints, indexes, and triggers are recorded in the system catalog for the supertable, but not for subtables that inherit them. Fragmentation information, however, is recorded for both supertables and subtables. For more information about inheritance, refer to the HCL OneDB™ Guide to SQL: Tutorial.