Previous Topic: CREATE TABLENext Topic: Privileges

SQL Statements › CREATE TABLE › Description

Description

table-name

The name of the table you are creating. The name you supply, including the implicit or explicit qualifier, must not identify a table, view or synonym already described in the CA Datacom Datadictionary.

If you specify SQLMODE=ANSI or SQLMODE=FIPS in the Preprocessor options, the table name can be 1 to 18 characters in length.

If you specify SQLMODE=DATACOM for extended mode in the Preprocessor options, the table name can be 1 to 32 characters in length.

The qualified form is the name preceded by an authorization ID and a period, for example, auth-id.table-name (but do not use SYSADM for the auth-id). If you qualify the table-name, the qualifier designates the schema of the table. If you do not qualify the table-name, the default authorization ID is used as the qualifier. If the CREATE TABLE statement is embedded within a CREATE SCHEMA statement, the authid that qualifies the table must be the same as the authid that follows the AUTHORIZATION keyword.

column definition

See Column Definition for information on the column definition.

table constraint definition

See Table Constraint Definition for information on the table constraint definition.

IN area-name

Use this CA Datacom/DB extension to specify the name of the area in which the table data is to reside. The name you specify for the area must be the SQL name, not the CA Datacom Datadictionary occurrence name. The area must already exist in the CA Datacom Datadictionary and be cataloged to the Directory (CXX). If you do not specify the area-name, the table is placed in the default area. If you need to specify an area other than the default, or if the default area is full, see your Database Administrator for names of other areas you can specify when creating a table.

DATACOM_NAME name

Use this CA Datacom/DB extension to specify a three-character DATACOM NAME name (a TABLE entity-occurrence in CA Datacom Datadictionary ) for the table. If you do not specify a DATACOM NAME name, CA Datacom Datadictionary generates a name for you. (This is not the CA Datacom Datadictionary entity-occurrence name.)