SQL/MX 3.x Installation and Management Guide (H06.22+, J06.11+)

HP NonStop SQL/MX Installation and Management Guide—640325-001
6
8. Querying SQL/MX Metadata
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-29
Displaying the Attributes of a Schema 8-30
Displaying the Owner of a Schema 8-30
Displaying Table Information 8-31
Displaying All Tables in a Catalog 8-32
Displaying All Tables in a Schema 8-33
Displaying All DDL Locks on a Table 8-34
Displaying the Attributes of a Table
8-36
Displaying All Tables on a System
8-37
Displaying Information About Views 8-37
Displaying All Views in a Schema 8-38
Displaying the Attributes of a View 8-38
Displaying Information About SQL/MP Aliases 8-39
Displaying All SQL/MP Alias Names in a Schema 8-39
Displaying All Attributes of an SQL/MP Alias Name
8-40
Displaying Information About SPJs
8-40
Displaying Index Information 8-40
Determining Whether a Table Has Indexes 8-41
Displaying All Indexes for a Table 8-42