Creating or Re-creating a Table
You can create a table using the Create Table dialog box.
You can also recreate a table in one of two ways
To create a new table:
- Navigate under a connected database. The Explorer displays icons for Tables,
Views, and Procedures.
- Open the Create Table dialog box using either:
- The contextual menu for the Tables
- The contextual menus for an existing table
- Type the table name.
This name must follow conventions for table names in your database. Case
is usually insignificant and you must not use spaces.
- Select the owner of the new table from the possible names of database users.
The dialog box defaults to the name by which you are connected.
- Click either Add Column or Remove to add or remove columns from the table.
- Specify the column type and size. You must specify the column type but size
is optional for some data types.
All other properties are optional.
- Click OK to create the table.
To re-create a table and its structure using a database
snapshot:
- Right-click a table from the table node.
- Choose Grab Structure. This action stores the definition of a selected table
to a file in the file system.
- Type a file name in which to save the structure of the table (the table
definition).
- Right-click the Tables node (or the node of any table under the Tables node)
and choose Recreate Table.
- Select the name of a file from which you want to re-create a table.
- In the following dialog, specify the table name and click OK to re-create
the table. If you want to modify the table definition command click the Edit
table script button and edit the table definition command.
NOTE
You can recreate a table in a different database from the one from which
you saved the structure, even if the SQL syntax to create the second database
is different from the syntax of the first. You can thus create database-independent
schemas with the Database Explorer. For example, you can develop a complete
application with a Pointbase database. For deployment, you can transfer the
table structures to an Oracle database to create the Oracle database without
editing SQL.
Legal Notices