SQL/MX 2.x Installation and Management Guide (H06.04+)

HP NonStop SQL/MX Installation and Management Guide—540436-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-14
Querying system tables
•
Displaying System Schema Information on page 8-15
•
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-36
•
Displaying Information About SQL/MP Aliases on
page 8-38
•
Displaying Information About SPJs on page 8-39
•
Displaying Index Information on page 8-39
•
Displaying Partition Information on page 8-45
•
Displaying Constraint Information on page 8-47
•
Displaying Column Information on page 8-49
•
Displaying Information About Privileges on page 8-59
Obtaining other information
•
Displaying Object Integrity and Consistency on
page 8-63
•
Displaying Version Numbers on page 8-63
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.