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-2

Adding Objects to an SQL/MX Database

Table 9-1 summarizes the objects you can add to an SQL/MX database and identifies

the statement, command, or utility required for each add operation.

For additional information on creating (adding) objects, see:

•

Section 4, Understanding and Planning SQL/MX Tables

•

Section 7, Creating an SQL/MX Database

•

Section 11, Managing Database Applications

•

SQL/MX Reference Manual

Table 9-1. Adding Objects to an SQL/MX Database

Object Operation Statement, Command, or Utility

Catalog Add CREATE CATALOG statement

Column Add ALTER TABLE ADD COLUMN statement

Constraint Add ALTER TABLE ADD CONSTRAINT statement

Index Add CREATE INDEX statement

Partition Add MODIFY utility

Schema Add CREATE SCHEMA statement

SQL/MP alias Add CREATE SQLMP ALIAS statement

Stored procedures

in Java (SPJs)

Add CREATE PROCEDURE statement

Table Add CREATE TABLE statement

Trigger Add CREATE TRIGGER statement

View Add CREATE VIEW statement