SQL/MX 3.2 Management Manual (H06.25+, J06.14+)

--- SQL operation complete.
>> select substring(object_name, 1, 15) as TABLENAME,
case object_security_class
when 'UM' then 'USER METADATA TABLE'
when 'UT' then 'USER-DEFINED TABLE'
when 'SM' then 'SYSTEM METADATA TABLE'
when 'MU' then 'OTHER'
end as SECURITY_CLASS,
create_time,
object_owner as owner
from objects
where object_type = 'BT'
and schema_uid =
(
select schema_uid
from nonstop_sqlmx_<system name>.system_schema.schemata
where
schema_name = 'SALES' and
cat_uid =
(select cat_uid
from nonstop_sqlmx_<sys_nam>.system_schema.catsys
where cat_name = 'SAMDBCAT'
)
)
for read uncommitted access
order by object_name;
OWNER
-----------
CREATE_TIME
--------------------
SECURITY_CLASS
---------------------
TABLENAME
---------------
65535
65535
212159239083886027
212159239072602110
USER-DEFINED TABLE
USER METADATA TABLE
CUSTOMER
HISTOGRAMS
65535212159239072602110USER METADATA TABLEHISTOGRAMS_FREQ
65535212159239072602110USER METADATA TABLEHISTOGRAM_INTER
65535212159239072602110OTHERMVS_TABLE_INFO_
65535212159239072602110OTHERMVS_UMD
65535212159239072602110OTHERMVS_USED_UMD
65535212159239086666918USER-DEFINED TABLEODETAIL
65535
65535
212159239084274760
212159239086955851
USER-DEFINED TABLE
USER-DEFINED TABLE
ORDERS
PARTS
Displaying all Tables on a System
Displaying all tables on a node (system) is a two-step process. To display all tables on a node,
you must:
1. Run a query that displays all the catalogs on a node (see “Displaying all Catalogs Visible on
a Node” (page 118)).
2. Run a query for each catalog that displays all the tables for that catalog (see “Displaying all
Tables in a Catalog” (page 125)).
If your database is distributed over multiple nodes, you must run a query for each node that displays
the catalogs on that node.
Displaying Information About Views
Topics in this subsection:
• “Displaying all Views in a Schema” (page 129)
• “Displaying the Attributes of a View” (page 129)
Related topics:
• “Displaying all Columns in a View” (page 139)
• “Displaying all Privileges for a View” (page 145)
128 Querying SQL/MX Metadata