Instruction Manual

6 Viewing database objects
This chapter discusses the following topics:
• “Viewing catalogs and their objects” (page 48)
• “Viewing schemas” (page 50)
• “Viewing table properties” (page 53)
• “Viewing schema views and their properties” (page 65)
• “Viewing procedures and their properties” (page 68)
• “Viewing SQL/MP aliases and their properties” (page 72)
• “Viewing table statistics and their properties” (page 75)
• “Viewing sequence generators and their properties” (page 73)
For information on the database objects, see the HP NonStop SQL/MX Release 3.2.1 Reference
Manual.
Viewing catalogs and their objects
To view the catalogs on a system:
1. Log on to the HP NonStop SQL/MX Database Manager.
2. In the navigation tree pane, click Database.
MXDM displays a list of existing systems.
3. Expand the contents of the system in the navigation tree.
The list of catalogs appear.
48 Viewing database objects