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

Contents
HP NonStop SQL/MX Installation and Management Guide—523723-004
vii
8. Querying SQL/MX Metadata (continued)
Displaying All Schemas Visible on a Node 8-27
8. Querying SQL/MX Metadata (continued)
Displaying All Objects in a Schema 8-28
Displaying the Attributes of a Schema 8-29
Displaying the Owner of a Schema 8-29
Displaying Table Information 8-30
Displaying All Tables in a Catalog 8-31
Displaying All Tables in a Schema 8-32
Displaying All DDL Locks on a Table 8-33
Displaying the Attributes of a Table 8-34
Displaying All Tables on a System 8-35
Displaying Information About Views 8-35
Displaying All Views in a Schema 8-36
Displaying the Attributes of a View 8-36
Displaying Information About SQL/MP Aliases 8-37
Displaying All SQL/MP Alias Names in a Schema 8-37
Displaying All Attributes of an SQL/MP Alias Name 8-38
Displaying Information About SPJs 8-38
Displaying Index Information 8-38
Determining Whether a Table Has Indexes 8-39
Displaying All Indexes for a Table 8-40
Displaying All DDL Locks on an Index 8-41
Displaying the Attributes of an Index 8-42
Displaying the State of Indexes for a Table 8-43
Displaying Partition Information 8-44
Displaying All Partitions for a Table or Index 8-44
Displaying Attributes of a Partition 8-45
Displaying Constraint Information 8-46
Determining Whether a Table Has Constraints 8-46
Displaying All Constraints on a Table 8-47
Displaying the Attributes of a Constraint 8-48
Displaying Column Information 8-48
Displaying All Columns in a Table 8-50
Displaying All Columns in a View 8-51
Displaying All Columns in an Index 8-52
Displaying All Columns in a Primary Key or Unique Constraint 8-53
Displaying All Columns in a NOT NULL Constraint 8-54
Displaying All Columns in a Referential Integrity Constraint 8-55