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

Querying SQL/MX Metadata
HP NonStop SQL/MX Installation and Management Guide—523723-004
8-30
Displaying Table Information
Displaying Table Information
Topics in this subsection:
•
Displaying All Tables in a Catalog on page 8-31
•
Displaying All Tables in a Schema on page 8-32
•
Displaying All DDL Locks on a Table on page 8-33
•
Displaying the Attributes of a Table on page 8-34
•
Displaying All Tables on a System on page 8-35
Related topics:
•
Locating System Schema Tables on page 8-15
•
Locating System Defaults Schema Tables on page 8-18
•
Determining Whether a Table Has Indexes on page 8-39
•
Displaying All Indexes for a Table on page 8-40
•
Displaying the State of Indexes for a Table on page 8-43
•
Displaying All Partitions for a Table or Index on page 8-44
•
Determining Whether a Table Has Constraints on page 8-46
•
Displaying All Constraints on a Table on page 8-47
•
Displaying All Columns in a Table on page 8-50
•
Displaying All Privileges for a Table on page 8-59
For detailed information about metadata tables, see Table 8-1 on page 8-6 or the
SQL/MX Reference Manual.
All queries for information about a specific table object must access information from
the CATSYS, SCHEMATA, and OBJECTS tables, and from the appropriate specific
table (for example, the COLS table or the PARTITIONS table).