SQL/MX 3.x Installation and Management Guide (H06.22+, J06.11+)

HP NonStop SQL/MX Installation and Management Guide—640325-001
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-10
Querying system tables
•
Displaying System Schema Information on page 8-11
•
Displaying Catalog Information on page 8-23
•
Displaying Schema Information on page 8-26
Querying objects and other
tables
•
Displaying Table Information on page 8-31
•
Displaying Information About Views on page 8-37
•
Displaying Information About SQL/MP Aliases on
page 8-39
•
Displaying Information About SPJs on page 8-40
•
Displaying Index Information on page 8-40
•
Displaying Partition Information on page 8-46
•
Displaying Constraint Information on page 8-48
•
Displaying Column Information on page 8-50
•
Displaying Information About Privileges on page 8-60
Obtaining other information
•
Displaying Object Integrity and Consistency on
page 8-64
•
Displaying Version Numbers on page 8-64
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.