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

Contents
HP NonStop SQL/MX Installation and Management Guide—544536-007
viii
8. Querying SQL/MX Metadata (continued)
8. Querying SQL/MX Metadata (continued)
Displaying All Privileges for a View 8-58
Displaying All Privileges for a Column 8-59
Displaying Object Integrity and Consistency 8-60
Displaying Version Numbers 8-60
Displaying the NonStop SQL/MX Release Identifier 8-60
Displaying the Schema Version 8-61
Displaying the System Schema Version 8-61
Displaying the Object Schema Version (OSV) 8-61
Displaying the Object Feature Version (OFV) 8-61
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
Adding Partitions to SQL/MX Tables and Indexes 9-11
Adding Schemas 9-13
Adding SQL/MP Aliases 9-14
Adding Stored Procedures in Java (SPJs) 9-14
Adding SQL/MX Tables 9-14
Adding Triggers 9-16
Adding Views 9-17
Altering Objects in an SQL/MX Database 9-18
Authorization Requirements for Altering Database Objects 9-19
Altering SQL/MX Indexes 9-20
Altering Partitions for SQL/MX Tables and Indexes 9-21
Altering SQL/MP Aliases 9-21
Altering SPJs 9-22
Altering System Defaults 9-22
Altering SQL/MX Tables 9-22
Altering Triggers 9-25
Altering Views 9-25
Dropping Objects From an SQL/MX Database 9-26
Authorization Requirements for Dropping Database Objects 9-26
Dropping Catalogs 9-28