SQL/MP Installation and Management Guide

Adding, Altering, Removing, and Renaming
Database Objects
HP NonStop SQL/MP Installation and Management Guide—523353-004
7-14
Altering Database Objects
All changes to a database require the specified authority for protection of the database.
The authority to alter existing objects is controlled by the ownership and security of that
object. For details on authorization requirements, see Authorization Requirements for
Database Operations on page 4-5.
This table summarizes the database objects that can be altered and the statements,
commands, and options you use for the operations:
Object Operation Statement or Command (page 1 of 2)
Catalog (all tables) Security ALTER CATALOG
Catalog tables
PROGRAMS
USAGES
TRANSIDS
CATALOGS
Security ALTER TABLE
Table Security/attributes ALTER TABLE
SECURE
View Security
Column attributes
Heading text
Help text
ALTER VIEW
SECURE
ALTER VIEW COLUMN
ALTER VIEW COLUMN
HELP TEXT
Index File attributes ALTER INDEX
Partition File attributes
Add/split/move
Drop
ALTER TABLE PARTONLY
ALTER INDEX PARTONLY
ALTER TABLE PARTONLY MOVE
ALTER INDEX PARTONLY MOVE
ALTER TABLE DROP PARTITION
ALTER INDEX DROP PARTITION
Column New definition
Column attributes
Heading text
Help text
CREATE TABLE
LOAD
DROP TABLE
ALTER TABLE ADD COLUMN
ALTER TABLE COLUMN
ALTER TABLE COLUMN
HELP TEXT