Working with tables

When a database is first created, the only tables in the database are the system tables. System tables hold the database schema.

This section describes how to create, alter, and drop tables. You can execute the examples in Interactive SQL, but the SQL
statements are independent of the administration tool you use. See Editing result sets in Interactive SQL.

To make it easier for you to re-create the database schema when necessary, create command files to define the tables in your
database. The command files should contain the CREATE TABLE and ALTER TABLE statements.