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

HP NonStop SQL/MX Installation and Management Guide—523723-004
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-14
Querying system tables
•
Displaying System Schema Information on page 8-15
•
Displaying Catalog Information on page 8-22
•
Displaying Schema Information on page 8-25
Querying objects and other
tables
•
Displaying Table Information on page 8-30
•
Displaying Information About Views on page 8-35
•
Displaying Information About SQL/MP Aliases on
page 8-37
•
Displaying Information About SPJs on page 8-38
•
Displaying Index Information on page 8-38
•
Displaying Partition Information on page 8-44
•
Displaying Constraint Information on page 8-46
•
Displaying Column Information on page 8-48
•
Displaying Information About Privileges on page 8-58
Obtaining other information
•
Displaying Object Integrity and Consistency on
page 8-62
•
Displaying Version Numbers on page 8-62
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.