SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

HP NonStop SQL/MX Installation and Management Guide—544536-007
8-1
8 Querying SQL/MX Metadata
Use the commands described in this section to obtain the information you need to
manage a database. This section addresses these topics:
Metadata overview
•
Commands for Displaying Information on page 8-2
•
SQL/MX Metadata Tables on page 8-5
•
Understanding ANSI External and Internal Names on
page 8-11
Querying system tables
•
Displaying System Schema Information on page 8-12
•
Displaying Catalog Information on page 8-20
•
Displaying Schema Information on page 8-23
Querying objects and other
tables
•
Displaying Table Information on page 8-28
•
Displaying Information About Views on page 8-33
•
Displaying Information About SQL/MP Aliases on
page 8-35
•
Displaying Information About SPJs on page 8-36
•
Displaying Index Information on page 8-36
•
Displaying Partition Information on page 8-42
•
Displaying Constraint Information on page 8-44
•
Displaying Column Information on page 8-46
•
Displaying Information About Privileges on page 8-56
Obtaining other information
•
Displaying Object Integrity and Consistency on
page 8-60
•
Displaying Version Numbers on page 8-60
Note. For some metadata information, NSM/web provides an alternative to writing complex
queries. The NSM/web graphical user interface automatically displays all the catalogs,
schemas, and tables on a local node. For more information about NSM/web, see the NSM/web
Installation Guide or the NSM/web online help.