Creating Tables

Forte for Java enables you to create a database table with columns and to add this table to database. You can open the Create table dialog in either:

  1. The pop-up menu for Tables, or
  2. The pop-up menus for existing tables.

You can create a table for one database at time.

To create a table using the Create table dialog:

  1. Enter the Table name. This name must follow conventions for table names your database; case is usually
    insignificant and you must not use spaces.
  2. Select the Owner of the new table from the possible names of database users offered to you in the dialog.
    The dialog defaults to the name by which you are connected.
  3. Click Add column or Remove to add or remove columns from the table. Each displayed row will be a
    column in the new table.
  4. Once you have specified Name, Type, and Size, the table is created. All other properties are optional,
    according to your needs. See the description of Add column for details on customizing your table.
  5. Click OK to create the table.

Using a database snapshot to recreate a table and its structure without data:

  1. Right-click on a table.
  2. Select Grab structure.
  3. Forte for Java prompts you for a file name in which to save the structure of the table (the table definition.)
  4. Select Recreate table from the context menu of the Tables node, or
  5. Select Recreate table from the node of any table under the Tables node.
  6. Select a file name to load to send the proper SQL commands to the database to recreate a table.

Recreating tables in a different database:

You can recreate tables 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. To do so, you can, for example:

  1. Develop a complete application with a Pointbase database.
  2. For deployment, transfer the table structures to an Oracle database to create the Oracle database without editing SQL .
See also

Browsing Structures
Enabling and Disabling Debug Mode to Monitor SQL Commands
Adding and Copying Database Columns


Legal Notices