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

Contents
HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-001
vi
8. Querying SQL/MX Metadata
Creating Stored Procedures in Java 7-41
Database Design Guidelines for Improving OLTP Performance 7-41
8. Querying SQL/MX Metadata
Commands for Displaying Information 8-2
DISPLAY USE OF Command 8-2
mxtool INFO Command 8-3
SHOWLABEL Command 8-3
mxtool VERIFY command 8-3
SHOWDDL Command 8-4
SQL/MX Metadata Tables
8-5
Understanding ANSI External and Internal Names
8-10
Regular Identifiers and Object Naming 8-10
Delimited Identifiers and Object Naming 8-10
Displaying System Schema Information 8-11
Locating System Schema Tables 8-11
Locating System Defaults Schema Tables 8-16
Locating MXCS Schema Tables 8-21
Displaying Catalog Information 8-23
Displaying a Catalog UID 8-23
Displaying All Catalogs Visible on a Node 8-24
Determining Whether a Catalog is Local or Remote 8-24
Displaying All Schemas in a Catalog 8-25
Displaying the Guardian Location of the Metadata Tables for a Catalog 8-25
Displaying the Attributes of a Catalog 8-26
Displaying Schema Information
8-26
Displaying a Schema UID 8-27
Displaying All Schemas Visible on a Node
8-28
Displaying All Objects in a Schema
8-34
Displaying the Attributes of a Schema
8-35
Displaying the Owner of a Schema 8-35
Displaying Table Information
8-36
Displaying All Tables in a Catalog
8-37
Displaying All Tables in a Schema 8-38
Displaying All DDL Locks on a Table 8-39
Displaying the Attributes of a Table
8-41
Displaying All Tables on a System
8-42
Displaying Information About Views 8-42
Displaying All Views in a Schema 8-43