SQL/MX 3.x Installation and Management Guide (H06.22+, J06.11+)

Querying SQL/MX Metadata
HP NonStop SQL/MX Installation and Management Guide—640325-001
8-31
Displaying Table Information
>> select substring(schema_name, 1, 30) as schema_name,
schema_owner
from schemata s, catsys c
where cat_name = 'SAMDBCAT'
and s.cat_uid = c.cat_uid
for read uncommitted access;
SCHEMA_NAME SCHEMA_OWNER
------------------------------ ------------
DEFINITION_SCHEMA_VERSION_3000 65535
INVENT 65535
PERSNL 65535
SALES 65535
Displaying Table Information
Topics in this subsection:
•
Displaying All Tables in a Catalog on page 8-32
•
Displaying All Tables in a Schema on page 8-33
•
Displaying All DDL Locks on a Table on page 8-34
•
Displaying the Attributes of a Table on page 8-36
•
Displaying All Tables on a System on page 8-37
Related topics:
•
Locating System Schema Tables on page 8-11
•
Locating System Defaults Schema Tables on page 8-16
•
Determining Whether a Table Has Indexes on page 8-41
•
Displaying All Indexes for a Table on page 8-42
•
Displaying the State of Indexes for a Table on page 8-45
•
Displaying All Partitions for a Table or Index on page 8-46
•
Determining Whether a Table Has Constraints on page 8-48
•
Displaying All Constraints on a Table on page 8-49
•
Displaying All Columns in a Table on page 8-52
•
Displaying All Privileges for a Table on page 8-61
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).