Neoview Database Administrator's Guide (R2.2)

Displaying Table DDL Information
1. Start DB Admin and log on using any user ID. The DBA role is intended for this task.
2. Click the Database tab, then navigate to the schema. To display DDL information for all
tables in the schema, right-click the Tables folder and select DDL Tool:
3. To display DDL information for one table, click the Database tab, then navigate to the schema
and right-click the table name. DB Admin displays DDL information for this table:
You can also display DDL information by displaying the table’s properties and viewing the
DDL tab. See “Displaying Tables and Their Properties” (page 47).
Adding Columns to a Table
1. Start DB Admin and log on using the user ID that created the table or log on as a user
authorized to make changes to that table.
2. Click the Database tab, then navigate to the schema and table you want to change.
3. Right-click the table name and select Alter, then Add Column(s) or click the Columns tab,
then the Add Columns button in the right pane. Provide information for the new column
and click OK:
Tables 51