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

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