Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.4.1 - User Guide

SQL Optimizer for IBM® DB2® LUW
UsageStatistics Getting Started Options SQL Scanner SQL Optimizer SQL Formatter SQL Inspector Database Explorer SQL Repository Index Impact Analyzer Index Usage Analyzer User-Defined Temp Table Editor Functions SQL Functions SQL Information and Functions Activity Log
Tutorials About us Copyright

About Database Explorer

The Database Explorer accesses information on database objects from the database server and provides details on tables, views, aliases, nicknames, procedures, functions, triggers, packages and user-defined types. The type of information given is dependent on the object type and your privileges to access specific database objects.

 

Related Topics

Database Explorer Window

ClosedView the Database Explorer

The Database Explorer window is divided into two sections:

Database Objects

Displays a tree diagram of the database objects these include schemas, tables, views, aliases, procedures, functions, triggers, packages, nicknames and user-defined types.

Object Information

Displays relevant information of the selected database object.

 

Privileges

User privileges within the database server are directly reflected in the Database Explorer. Schema with full access will be able to view all database objects within the catalog. Otherwise, those granted to the schema will be viewable.

 

Opening Database Explorer

To open the Database Explorer window

  1. Click image\B_DatabaseExplorer.gif.

 

Related Documents