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

Adding, Altering, and Dropping SQL/MX Database
Objects
HP NonStop SQL/MX Installation and Management Guide—523723-004
9-18
Altering Objects in an SQL/MX Database
Altering Objects in an SQL/MX Database
Table 9-3 summarizes the database objects that you can alter and identifies the
statements, commands, or utilities to use.
For additional information on altering SQL/MX database objects, see:
•
Section 4, Understanding and Planning SQL/MX Tables
•
Section 6, Reviewing and Setting System Defaults
•
Section 7, Creating an SQL/MX Database
•
Section 11, Managing Database Applications
•
SQL/MX Reference Manual
Table 9-3. Altering Objects in an SQL/MX Database
Object Operation Statement, Command, or Utility
Index Change attributes ALTER INDEX statement
FIXUP utility
Partition Add partition MODIFY utility
Drop partition MODIFY utility
Reuse partition MODIFY utility
Move partition MODIFY utility
Stored procedure in
Java (SPJ)
Grant privilege GRANT statement
GRANT EXECUTE statement
Revoke privilege REVOKE statement
REVOKE EXECUTE statement
SQL/MP alias Remap ALTER SQLMP ALIAS statement
System Default Changing attribute
settings
See Section 6, Reviewing and Setting System
Defaults
Table Change attributes ALTER TABLE statement
FIXUP utility
Add column ALTER TABLE statement
Add constraint ALTER TABLE statement
Drop constraint ALTER TABLE statement
Grant privileges GRANT statement
Revoke privileges REVOKE statement
Trigger Enable trigger ALTER TRIGGER statement
Disable trigger ALTER TRIGGER statement
View Grant privilege GRANT statement
Revoke privilege REVOKE statement