To create a sample table, which will be accessed by the
sample stored procedures, do the following:
- Right-click
the Tables folder of your schema and select New -> With
SQL Editor.
- Change the text in the editor to the following, replacing mysche with
the name of the schema folder:
CREATE TABLE mysche.CITYTABLE (
CITY CHAR(32) NOT NULL,
COUNTRY CHAR(32) NOT NULL,
PRIMARY KEY(CITY) );
- Right-click the white space in the editor and click Run
SQL. The Data Output view should indicate
a successful run.
- Close the SQL editor without saving the contents.
- Right-click the Tables folder and click Refresh The new table definition appears in the Tables folder
of your schema.
| Column name |
Column type |
Length |
| CITY |
VARCHAR |
32 |
| COUNTRY |
VARCHAR |
32 |