Table Operations

You can create, delete, rename or checkpoint and restore tables.

Table Creation

Relationships between tables and records are established when the tables and records are first created. The parent table must be designated as such when it is created. The child table must be designated as such when it is created, and the parent table must be specified for the child table.

Table Deletion

A parent table cannot be deleted if any child tables for that parent exist. A child table can be deleted at any time. Deleting a parent record causes all child records of that parent record to become orphans. The parent key must be known and used to access the orphaned child record.

Table Rename

Parent and child tables can be renamed at any time.

Table Checkpoint and Restoration

Checkpoint and restore a parent and all of its child tables as a unit.