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

HP NonStop SQL/MX Installation and Management Guide—640325-001
7
9. Adding, Altering, and Dropping SQL/MX
Database Objects
Displaying All DDL Locks on an Index 8-43
Displaying the Attributes of an Index 8-44
Displaying the State of Indexes for a Table 8-45
Displaying Partition Information 8-46
Displaying All Partitions for a Table or Index 8-46
Displaying Attributes of a Partition 8-47
Displaying Constraint Information 8-48
Determining Whether a Table Has Constraints 8-48
Displaying All Constraints on a Table 8-49
Displaying the Attributes of a Constraint 8-50
Displaying Column Information 8-50
Displaying All Columns in a Table 8-52
Displaying All Columns in a View 8-53
Displaying All Columns in an Index 8-54
Displaying All Columns in a Primary Key or Unique Constraint 8-55
Displaying All Columns in a NOT NULL Constraint 8-56
Displaying All Columns in a Referential Integrity Constraint 8-56
Displaying the Attributes of a Column 8-58
Displaying All Tables Containing a Selected Column 8-59
Displaying Information About Privileges 8-60
Displaying All Privileges for a Table 8-61
Displaying All Privileges for a View 8-62
Displaying All Privileges for a Column 8-63
Displaying Object Integrity and Consistency 8-64
Displaying Version Numbers 8-64
Displaying the NonStop SQL/MX Release Identifier 8-64
Displaying the Schema Version 8-65
Displaying the System Schema Version
8-65
Displaying the Object Schema Version (OSV)
8-65
Displaying the Object Feature Version (OFV) 8-65
9. Adding, Altering, and Dropping SQL/MX Database Objects
Planning Operations on SQL/MX Objects 9-1
Adding Objects to an SQL/MX Database 9-2
Authorization Requirements for Adding Database Objects 9-3
Adding Catalogs 9-4
Adding Columns to an SQL/MX Table 9-5
Adding Constraints 9-7
Adding Indexes to SQL/MX Tables 9-8