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-37
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-24).
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-32).
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-38
•
Displaying the Attributes of a View on page 8-38
Related topics:
•
Displaying All Columns in a View on page 8-53
•
Displaying All Privileges for a View on page 8-62
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 Figure 8-2 on page 8-7 in this manual 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.