SQL/MX 3.1 Installation and Management Guide (H06.23+, J06.12+)

Querying SQL/MX Metadata
HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-001
8-39
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-25).
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-34).
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-40

Displaying the Attributes of a View on page 8-40
Related topics:

Displaying All Columns in a View on page 8-55

Displaying All Privileges for a View on page 8-64
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.