Creating a table

You can define a new table to an existing database by issuing a CREATE TABLE statement. This can be useful if you find that you need to add another child to the hierarchy of your database.

Ensure you do not exceed the maximum number of tables for your database type.

Procedure

  1. Issue an ALTER DATABASE statement to identify the database in which you plan to include the new table.
  2. Issue a CREATE TABLE statement. Ensure that you also provide the IN keyword to reference it to the database and table space it belongs to.
  3. Specify a FOREIGN KEY in your CREATE TABLE statement to identify its parent.
  4. Issue a COMMIT DDL statement.