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-35
Displaying All Tables on a System
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 on page 8-23).
2. Run a query for each catalog that displays all the tables for that catalog (see
Displaying All Tables in a Catalog on page 8-31).
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 on page 8-36
•
Displaying the Attributes of a View on page 8-36
Related topics:
•
Displaying All Columns in a View on page 8-51
•
Displaying All Privileges for a View on page 8-60
The VWS table is the definition schema table that lists all views in a catalog. Text for
views is stored separately in the TEXT table. For detailed information about all
metadata tables, see Table 8-1 on page 8-6 or the SQL/MX Reference Manual.
All queries for information about a specific view must access information from the
CATSYS, SCHEMATA, and OBJECTS tables, and from the VWS table.