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

Contents
HP NonStop SQL/MX Installation and Management Guide—640325-001
viii
9. Adding, Altering, and Dropping SQL/MX
Database Objects
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
Dropping Columns from an SQL/MX Table 9-28
Dropping Constraints 9-29
Dropping SQL/MX Indexes 9-30
Dropping Partitions for SQL/MX Tables and Indexes 9-31
Dropping Schemas 9-32
Dropping SQL/MP Aliases 9-33
Dropping SPJs 9-34
Dropping SQL/MX Tables 9-34
Dropping Triggers 9-36
Dropping Views 9-37