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:
- The pop-up menu for Tables, or
- 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:
- Enter the Table name. This name must follow conventions for table names
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
offered to you in the dialog.
The dialog defaults to the name by which you are connected.
- Click Add column or Remove to add or remove columns from the table. Each
displayed row will be a
column in the new table.
- 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.
- Click OK to create the table.
Using a database snapshot to recreate a table and its structure without
data:
- Right-click on a table.
- Select Grab structure.
- Forte for Java prompts you for a file name in which to save the structure
of the table (the table definition.)
- Select Recreate table from the context menu of the Tables node, or
- Select Recreate table from the node of any table under the Tables node.
- 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:
- Develop a complete application with a Pointbase database.
- For deployment, transfer the table structures to an Oracle database to create
the Oracle database without editing SQL .
Legal Notices