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

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

 See also