CREATE TABLE

In the following table, YES indicates a valid execution method for this statement.

This SQL statement can be executed in the following ways:	Through the CA Datacom Datadictionary Interactive SQL Service Facility (interactive)	In an application program prepared using a CA Datacom/DB SQL Preprocessor (embedded)	By using CA Dataquery (SQL & Batch Modes)
CREATE TABLE	YES	YES	YES

To learn about using SQL keywords in CA Dataquery, see the CA Dataquery User Guide.

For information about the access rights required to execute this statement, see the CA Datacom/DB Database and System Administration Guide.

Note: If you are using CA Datacom/DB as part of the CA Datacom/AD environment, you cannot use the CREATE TABLE statement.

CREATE TABLE defines a table. In this statement, you must specify:

The name of the table, and
The column definition for the table.

Optional specifications include:

The table constraint definition for the table.
Designating more than one column definition.
Designating one or more table constraint definitions.
Naming the data area where the table data is to reside.

When a CREATE TABLE statement successfully executes, a TABLE entity-occurrence is defined in CA Datacom Datadictionary in PRODuction status, cataloged to the CA Datacom/DB Directory (CXX), and is ready to be populated with data. See Results of Defining Structures Using SQL Statements for information about the results in CA Datacom Datadictionary of using the CREATE TABLE statement.

With regard to table partitioning, CREATE statements may not be issued against a table which is partitioned nor against a partition. An SQL integrity constraint cannot reference a partitioned table, nor a partition of a partitioned table. That is to say, constraints and partitioned tables are mutually exclusive. For more information about table partitioning, see the CA Datacom/DB Database and System Administration Guide.

Following is the syntax diagram for the CREATE TABLE statement:

                                ┌─ , ─────────────────────┐
►►─ CREATE TABLEtable-name ─ ( ─▼─┬─ column definition ───┴─ ) ───┬───►
                                  └─ table constraint definition ─┘
►─┬────────────────┬─┬────────────────────┬───────────────────────────►◄
  └─ IN area-name ─┘ └─ DATACOM_NAMEname ─┘

Notes:

DATACOM_NAME name is a CA Datacom/DB extension.

IN area-name is a CA Datacom/DB extension.