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
vii
8. Querying SQL/MX Metadata
Displaying the Attributes of a View 8-43
Displaying Information About SQL/MP Aliases 8-44
Displaying All SQL/MP Alias Names in a Schema 8-44
Displaying All Attributes of an SQL/MP Alias Name 8-45
Displaying Information About SPJs 8-45
Displaying Index Information 8-45
Determining Whether a Table Has Indexes 8-46
Displaying All Indexes for a Table 8-47
Displaying All DDL Locks on an Index 8-48
Displaying the Attributes of an Index
8-49
Displaying the State of Indexes for a Table
8-50
Displaying Partition Information 8-51
Displaying All Partitions for a Table or Index 8-51
Displaying Attributes of a Partition 8-52
Displaying Constraint Information 8-53
Determining Whether a Table Has Constraints 8-53
Displaying All Constraints on a Table 8-54
Displaying the Attributes of a Constraint 8-55
Displaying Column Information 8-55
Displaying All Columns in a Table 8-57
Displaying All Columns in a View 8-58
Displaying All Columns in an Index 8-59
Displaying All Columns in a Primary Key or Unique Constraint 8-60
Displaying All Columns in a NOT NULL Constraint 8-61
Displaying All Columns in a Referential Integrity Constraint
8-61
Displaying the Attributes of a Column 8-63
Displaying All Tables Containing a Selected Column
8-64
Displaying Information About Privileges
8-65
Displaying All Privileges for a Table
8-66
Displaying All Privileges for a View 8-67
Displaying All Privileges for a Column
8-68
Displaying Object Integrity and Consistency
8-69
Displaying Version Numbers 8-69
Displaying the NonStop SQL/MX Release Identifier 8-69
Displaying the Schema Version 8-70
Displaying the System Schema Version 8-70
Displaying the Object Schema Version (OSV) 8-70
Displaying the Object Feature Version (OFV) 8-70