SQL/MP Installation and Management Guide

Contents
HP NonStop SQL/MP Installation and Management Guide—523353-004
v
7. Adding, Altering, Removing, and Renaming
Database Objects (continued)
7. Adding, Altering, Removing, and Renaming Database
Objects (continued)
Adding Partitions to Tables and Indexes 7-7
Adding Columns 7-10
Adding Constraints 7-12
Adding Collations 7-13
Adding Comments 7-13
Altering Database Objects 7-13
Altering Catalog Attributes 7-15
Altering Table Attributes 7-15
Altering View Attributes 7-18
Altering Index Attributes 7-19
Altering Partition Attributes 7-19
Splitting, Moving, and Merging Partitions 7-20
Altering Columns 7-26
Altering Constraints 7-27
Altering Collation Attributes 7-27
Altering Comments 7-28
Dropping Objects From a Database 7-28
Dropping Catalogs 7-29
Dropping Tables 7-30
Dropping Views 7-30
Dropping Indexes 7-31
Dropping Partitions of Tables and Indexes 7-32
Deleting Columns 7-33
Dropping Constraints
7-34
Dropping Collations
7-34
Dropping Comments 7-35
Purging SQL Objects and Enscribe Files 7-35
Using DROP or PURGE 7-35
Renaming Objects 7-36
8. Reorganizing Tables and Maintaining Data
Choosing a Reorganization Method 8-1
Reorganizing a Database Online 8-2
Reorganizing Key-Sequenced Files 8-2
Determining the Status of a Reorganization 8-4
Suspending a Reorganization Operation 8-4
Reorganizing Partitions 8-5