SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

Querying SQL/MX Metadata
HP NonStop SQL/MX Installation and Management Guide—544536-007
8-33
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-21).
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-29).
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-34
•
Displaying the Attributes of a View on page 8-34
Related topics:
•
Displaying All Columns in a View on page 8-49
•
Displaying All Privileges for a View on page 8-58
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.