TABLE_INFO Statement

Schema Files Syntax › TABLE_INFO Statement

TABLE_INFO Statement

This instructs your database management system how to store and index data in the logical tables. The extent to which these instructions are followed depends on the database management system. If no instructions are provided, the database management system follows its own storage and indexing instructions.

Syntax

TABLE_INFO table_name {

[STORAGE storage_mtd Field ;]
[INDEX ndx_props field1 [field2 ...];] ...}

Arguments

TABLE_INFO

Introduces the TABLE_INFO statement. Must be uppercase. The TABLE_INFO statement is optional, but if specified, you can have only one TABLE_INFO for each TABLE statement, and it must follow the TABLE statement.

table_name

The name of the database table in the TABLE statement.

STORAGE storage_mtd

Identifies the storage method. Valid values are listed as follows, but note that some database management systems ignore these values:

Value	Description
BTREE	Indicates to use the balanced tree storage method.
HASH	Indicates to use the hash table storage method. This is valid only if the field is the primary key.
HEAP	Indicates to use the heap storage method.

field

Identifies the column that is to be stored according to the specified storage method (STORAGE storage_mtd). Must be specified the same way as the name of the column in the TABLE statement.

INDEX ndx_props

Identifies one or more properties for an index that consists of the fields specified. Valid values are:

Value	Description
SORT ASCENDING \| DESCENDING	Indicates whether to sort the data in the fields in ascending or descending order. Data is sorted in ascending order by default; therefore, only SORT DESCENDING need be specified.
PRIMARY	Indicates to use this index as the default sort order for the table.
CLUSTER	Identifies this as a clustering index.
UNIQUE	Indicates that values in the index must be unique.

field1 [field2 . . .]

Identifies the column or columns that are to be indexed according to the specified index properties (INDEX ndx_props). Must be specified the same way as the name of the columns in the TABLE statement.

Examples

This TABLE_INFO statement instructs the database management system to use a hash table to store values in the id field in the Contact_Type table, and to sort the table in descending order according to the values in the sym field. It also indicates that values must be unique:

TABLE_INFO Contact_Type {

STORAGE HASH id;
INDEX SORT DESCENDING PRIMARY UNIQUE sym;
}