On the Columns tab, each row represents a single
column, and contains all of the attributes for that column.
- Use the values in the following table to create
the first column. Leave the PKey box checked. Leave the ID, Size, Scale, Nulls, Unique and Comments attributes
blank
Pkey
|
Name
|
Data type
|
|---|
¸
|
office_id
|
integer
|
- To create a new column:
- Tab to
the end of the current row.
- Click the New Column button on the Toolbar.
- Click File, point to New, and choose Column.
- Use these attributes to create columns for the office table.
Name
|
Data type
|
Size
|
Nulls
|
|---|
region
|
char
|
7
|
¸
|
street
|
char
|
40
|
¸
|
city
|
char
|
20
|
¸
|
state
|
char
|
2
|
¸
|
zip
|
char
|
9
|
¸
|
- To save the column definitions:
- Click
the Save Table button on the Toolbar.
- Click File, and choose Save.
The office table is now visible on the
tables tab in the right pane of Sybase Central. The office table
is now part of the iqdemo database. To add
data, click the Data tab, right-click, and choose Add Row, or you
can use the Interactive SQL utility. The following section describes
how to edit an existing table.