Using the New Table Wizard

The New Table wizard is used to create new tables. It performs such functions as allowing you to enter new fields, select field data types, and generate SQL statements. Once information is entered into all the fields, the SQL statement can be modified to include additional information, such as primary key, foreign key, or tablespace information.

Perform the following steps to access this wizard:

1          Click the Catalog Details tab.

2          Click Admin Tasks:

3          Click Create New Table. A window similar to the following displays:

4          Type a name for the table in the Table Name field.

5          In the table grid, type the field names and select the desired data type and other options for each field.

As you type field values, WinSQL generates the CREATE TABLE statement for your new table.