Show TOC

Table IDLocate this document in the navigation structure


Each table in the database has a table ID of a fixed length, which uniquely identifies the table. The database system uses the table ID to access a table.

To access a table with an SQL statement, you specify the table name (not the table ID).

The allocation of the table name to the table ID is stored in the database catalog; the allocation of the table ID to the B* trees is stored in the internal file directory.

More Information

Concepts of the Database System, Logical Access Structures