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

Querying SQL/MX Metadata
HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-001
8-33
Displaying Table Information
c, NONSTOP_SQLMX_COBOLT.SYSTEM_SECURITY_SCHEMA.MGM_PRIVILEGES m
where c.cat_uid = m.target_uid;
GRANTEE PRIVILEGE_TYPE CAT_NAME
----------- -------------- ----------
44802 CS CAT1
--- 1 row(s) selected.
Displaying Table Information
This subsection discusses the following topics:

Displaying All Tables in a Catalog on page 8-34

Displaying All Tables in a Schema on page 8-35

Displaying All DDL Locks on a Table on page 8-36

Displaying the Attributes of a Table on page 8-38

Displaying All Tables on a System on page 8-39
Related topics:

Locating System Schema Tables on page 8-12

Locating System Defaults Schema Tables on page 8-17

Determining Whether a Table Has Indexes on page 8-43

Displaying All Indexes for a Table on page 8-44

Displaying the State of Indexes for a Table on page 8-47

Displaying All Partitions for a Table or Index on page 8-48

Determining Whether a Table Has Constraints on page 8-50

Displaying All Constraints on a Table on page 8-51

Displaying All Columns in a Table on page 8-54

Displaying All Privileges for a Table on page 8-63
For detailed information about metadata tables, see Figure 8-2
on page 8-7 in this
manual 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).