SQL/MX 2.x Installation and Management Guide (H06.04+)

Contents
HP NonStop SQL/MX Installation and Management Guide—540436-001
vii
8. Querying SQL/MX Metadata (continued)
8. Querying SQL/MX Metadata (continued)
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-35
Displaying All Tables on a System 8-36
Displaying Information About Views 8-36
Displaying All Views in a Schema 8-37
Displaying the Attributes of a View 8-37
Displaying Information About SQL/MP Aliases 8-38
Displaying All SQL/MP Alias Names in a Schema 8-38
Displaying All Attributes of an SQL/MP Alias Name 8-39
Displaying Information About SPJs 8-39
Displaying Index Information 8-39
Determining Whether a Table Has Indexes 8-40
Displaying All Indexes for a Table 8-41
Displaying All DDL Locks on an Index 8-42
Displaying the Attributes of an Index 8-43
Displaying the State of Indexes for a Table 8-44
Displaying Partition Information 8-45
Displaying All Partitions for a Table or Index 8-45
Displaying Attributes of a Partition 8-46
Displaying Constraint Information 8-47
Determining Whether a Table Has Constraints 8-47
Displaying All Constraints on a Table 8-48
Displaying the Attributes of a Constraint 8-49
Displaying Column Information 8-49
Displaying All Columns in a Table 8-51
Displaying All Columns in a View 8-52
Displaying All Columns in an Index 8-53
Displaying All Columns in a Primary Key or Unique Constraint 8-54
Displaying All Columns in a NOT NULL Constraint 8-55
Displaying All Columns in a Referential Integrity Constraint 8-56
Displaying the Attributes of a Column 8-57
Displaying All Tables Containing a Selected Column 8-58
Displaying Information About Privileges 8-59
Displaying All Privileges for a Table 8-60
Displaying All Privileges for a View 8-61
Displaying All Privileges for a Column 8-62