SQL/MX 3.1 Installation and Management Guide (H06.23+, J06.12+)

HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-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-11
Querying system tables

Displaying System Schema Information on page 8-12

Displaying Catalog Information on page 8-24

Displaying Schema Information on page 8-27

Displaying users with catalog and schema creation
rights on page 8-32
Querying objects and other
tables

Displaying users with catalog and schema creation
rights on page 8-32

Displaying Information About Views on page 8-39

Displaying Information About SQL/MP Aliases on
page 8-41

Displaying Information About SPJs on page 8-42

Displaying Index Information on page 8-42

Displaying Partition Information on page 8-48

Displaying Constraint Information on page 8-50

Displaying Column Information on page 8-52

Displaying Information About Privileges on page 8-62
Obtaining other information

Displaying Object Integrity and Consistency on
page 8-66

Displaying Version Numbers on page 8-66
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.