Table Management

When you create a database, the only tables in it are the system tables, which hold the database schema.

You may need to create, alter, and delete tables from a database. You can execute examples in documentation using dbisql, but the SQL statements are independent of the administration tool you are using.

You can create command files containing the CREATE TABLE and ALTER TABLE statements that define the tables in your database and store them in a source code control system. The command files allow you to re-create the database when necessary. They also let you create tables in a standardized way, which you can copy and revise.