Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   SQL Statements > CREATE TABLE >

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 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 privileges that various CREATE TABLE options require. The systables, sysxtdtypes, and sysinherits system catalog tables provide information about table types.

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 IBM Informix Guide to SQL: Tutorial.

Related Information

Related statements: ALTER TABLE, CREATE INDEX, CREATE DATABASE, CREATE EXTERNAL TABLE (XPS), CREATE ROW TYPE , CREATE Temporary TABLE , DROP TABLE , SET Database Object Mode, and SET Transaction Mode

For Extended Parallel Server, see also SET Default Table Type and SET Default Table Space .

For discussions of database and table creation, including discussions on data types, data-integrity constraints, and tables in hierarchies, see the IBM Informix Database Design and Implementation Guide.

For information about the system catalog tables that store information about objects in the database, see the IBM Informix Guide to SQL: Reference. For information about the syschunks table (in the sysmaster database) that contains information about the location of smart large objects, see your IBM Informix Administrator's Reference.

Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]