Neoview Database Administrator's Guide (R2.2)

2. Click the Database tab, then navigate to the schema and table and click the index name in
the right pane, or open the Indexes folder. DB Admin displays the indexes for this table.
Click the index name in the lists in either pane. DB Admin displays the index’s information
in the right pane:
You can view more information with the Columns, Attributes, Space, and DDL tabs. Under
the DDL tab, the DDL Tool button displays DDL information.
For additional information, see DB Admin online help.
Display DDL information with the DDL Tool by right-clicking the index name in the tree
in the left pane and selecting DDL Tool.... DB Admin displays DDL information for this
index.
Dropping (Deleting) Indexes
1. Start DB Admin and log on using the user ID that created the table for which the index is
defined or log on as a user authorized to change that table.
2. Click the Database tab, then navigate to the schema, table, and its index.
3. Right-click the index name and then select Drop.
4. DB Admin prompts you to select RESTRICT or CASCADE to indicate if you want to drop
dependent objects. Select Drop:
5. DB Admin prompts you to confirm the drop. When you click Yes, it drops the index.
For additional information, see DB Admin online help.
Views
Since your Neoview platform is not preconfigured with tables, views are not configured, but
you can create them immediately.
Creating Views
1. Start DB Admin and log on using any user ID that is authorized to access the table or tables
for which you want to create a view.
60 Managing Database Objects