Maintaining Databases
Viewing Database Objects
The DBA must make sure important database objects, such as tables and views, are available, devise a way to separate temporary objects from important objects, and keep private objects to a minimum.
You can view database objects using the HELP statement. By using options such as INDEX, TABLE, and VIEW, you can obtain information on various types of database objects. For details, see the SQL Reference Guide.
You can view a list of database objects in Director by browsing in the Instance Explorer. Right click an object, and then select Properties.
In VDBA, in the Database Object Manager window, you can view details for any object in the tree by selecting it and using the panes to the right of the tree structure. By default, when you open a Database Object Manager window, only the objects belonging to you are visible. For more information, see VDBA online help.