When you create a database, the only tables in it are the system tables, which hold the database schema.
This section describes how to create, alter, and delete tables from a database. The examples can be executed in DBISQL, but the SQL statements are independent of the administration tool you are using.
For multiplex databases, all schema changes to be shared must be done on the write server. Follow these steps:
On the write server, execute DDL (Database Definition Language) commands.
Create database objects interactively or with scripts, just as you would with any Sybase IQ database. For complete syntax, see the Sybase IQ Reference Manual.
Insert the data. Perform the inserts on the write server while the multiplex runs.
If you use Interactive SQL to load tables, be sure to
enter a COMMIT command.
You may want to 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.
