Creating a new table from scratch
In PowerBuilder, you can create a new table in any database to
which PowerBuilder is connected.
To create a table in the current database
-
Do one of the following:
-
Click the Create Table button.
-
Right-click in the Columns view and select New Table
from the pop-up menu. -
Right-click Tables in the Objects view and select New
Table from the pop-up menu. -
Select Insert>Table from the Object menu.
The new table template displays in the Columns view. What
you see in the view is DBMS-dependent. You use this template to
specify each column in the table. The insertion point is in the
Column Name box for the first column. -
-
Enter the required information for this column.
For what to enter in each field, see Specifying column definitions.
As you enter information, use the Tab key to move from place
to place in the column definition. After defining the last item in
the column definition, press the Tab key to display the work area
for the next column. -
Repeat step 2 for each additional column in your
table. -
(Optional) Select Object>Pending Syntax from the menu bar
or select Pending Syntax from the pop-up menu to see the pending
SQL syntax.If you have not already named the table, you must provide a
name in the dialog box that displays. To hide the SQL syntax and
return to the table columns, select Object>Pending Syntax from
the menu bar. -
Click the Save button or select Save from the File or pop-up
menu, then enter a name for the table in the Create New Table
dialog box.PowerBuilder submits the pending SQL syntax statements it
generated to the DBMS, and the table is created. The new table is
displayed in the Object Layout view.About saving the table
If you make changes after you save the table and before
you close it, you see the pending changes when you select
Pending SQL again. When you click Save again, PowerBuilder
submits a DROP TABLE statement to the DBMS, recreates the table,
and applies all changes that are pending. Clicking Save many
times can be time consuming when you are working with large
tables, so you might want to save only when you have
finished. -
Specify extended attributes for the columns.
For what to enter in each field, see Specifying column extended
attributes.