SQL/MX 3.2.1 Management Manual (H06.26+, J06.15+)

c, NONSTOP_SQLMX_COBOLT.SYSTEM_SECURITY_SCHEMA.MGM_PRIVILEGES m
where c.cat_uid = m.target_uid;
CAT_NAME
----------
PRIVILEGE_TYPE
--------------
GRANTEE
-----------
CAT1CS44802
--- 1 row(s) selected.
Displaying Table Information
This subsection discusses the following topics:
• “Displaying all Tables in a Catalog” (page 125)
• “Displaying all Tables in a Schema” (page 127)
• “Displaying all DDL Locks on a Table” (page 127)
• “Displaying the Attributes of a Table” (page 128)
• “Displaying all Tables on a System” (page 129)
Related topics:
• “Locating System Schema Tables” (page 112)
• “Locating System Defaults Schema Tables” (page 114)
• “Determining Whether a Table has Indexes” (page 131)
• “Displaying all Indexes for a Table” (page 132)
• “Displaying the State of Indexes for a Table” (page 134)
• “Displaying all Partitions for a Table or Index” (page 135)
• “Determining Whether a Table Has Constraints” (page 136)
• “Displaying all Constraints on a Table” (page 137)
• “Displaying all Columns in a Table” (page 139)
• “Displaying all Privileges for a Table” (page 144)
For more information about metadata tables, see Figure 3 (page 109) 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).
Displaying all Tables in a Catalog
This example displays all base table objects in the catalog SAMDBCAT:
>> set schema samdbcat.definition_schema_version_schema version>;
--- SQL operation complete.
>> select substring (object_name, 1, 25) as table_name,
substring(schema_name, 1, 30) as schema_name
from nonstop_sqlmx_<system name>.system_schema.catsys c,
nonstop_sqlmx_<system name>.system_schema.schemata s,
objects o
where c.cat_uid = s.cat_uid
and c.cat_name = 'SAMDBCAT'
and s.schema_uid = o.schema_uid
and o.object_type = 'BT'
Displaying Table Information 125