SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-2
Data Definition Language (DDL) Statements
ALTER SEQUENCE Statement on
page 2-13
Alters SQL/MP alias attributes.
ALTER VIEW Statement
on
page 2-49
Renames a view within the schema, and modifies the
view by changing one or more file attributes for the
view.
CREATE CATALOG Statement
on
page 2-77
Creates a catalog on the local node.
CREATE INDEX Statement
on
page 2-79
Creates an index on a table.
CREATE PROCEDURE Statement
on page 2-87
Defines an existing Java method as an SPJ and
registers it in NonStop SQL/MX.
CREATE SCHEMA Statement
on
page 2-95
Creates a schema.
CREATE SEQUENCE Statement
on
page 2-99
Creates a sequence generator object in the specified
schema.
CREATE SQLMP ALIAS Statement
on page 2-103
Creates mappings from logical names to physical
names for SQL/MP database objects.
CREATE TABLE Statement
on
page 2-106
Creates a table.
CREATE TRIGGER Statement
on
page 2-143
Creates a trigger.
CREATE VIEW Statement
on
page 2-153
Creates a view.
DROP CATALOG Statement
on
page 2-179
Drops an empty catalog.
DROP INDEX Statement
on
page 2-180
Drops an index.
DROP PROCEDURE Statement
on
page 2-181
Drops an SPJ and its stored procedure label from
NonStop SQL/MX.
DROP SCHEMA Statement
on
page 2-182
Drops a schema.
DROP SEQUENCE Statement
on
page 2-184
Drops all the sequence generator objects in the
specified schema.
DROP SQL Statement
on
page 2-186
Removes NonStop SQL/MX from a local node.
DROP SQLMP ALIAS Statement
on
page 2-187
Drops mappings from logical names to physical
names for SQL/MP database objects.
DROP TABLE Statement
on
page 2-189
Drops a table.