SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
2-2
Data Definition Language (DDL) Statements
ALTER SQLMP ALIAS Statement on
page 2-10
Alters SQL/MP alias attributes.
ALTER VIEW Statement
on
page 2-42
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-70
Creates a catalog on the local node.
CREATE INDEX Statement
on
page 2-72
Creates an index on a table.
CREATE PROCEDURE Statement
on page 2-80
Defines an existing Java method as an SPJ and
registers it in NonStop SQL/MX.
CREATE SCHEMA Statement
on
page 2-88
Creates a schema.
CREATE SQLMP ALIAS Statement
on page 2-92
Creates mappings from logical names to physical
names for SQL/MP database objects.
CREATE TABLE Statement
on
page 2-95
Creates a table.
CREATE TRIGGER Statement
on
page 2-132
Creates a trigger.
CREATE VIEW Statement
on
page 2-142
Creates a view.
DROP CATALOG Statement
on
page 2-163
Drops an empty catalog.
DROP INDEX Statement
on
page 2-164
Drops an index.
DROP PROCEDURE Statement
on
page 2-165
Drops an SPJ and its stored procedure label from
NonStop SQL/MX.
DROP SCHEMA Statement
on
page 2-166
Drops a schema.
DROP SQL Statement
on
page 2-169
Removes NonStop SQL/MX from a local node.
DROP SQLMP ALIAS Statement
on
page 2-170
Drops mappings from logical names to physical
names for SQL/MP database objects.
DROP TABLE Statement
on
page 2-172
Drops a table.
DROP TRIGGER Statement
on
page 2-174
Drops a trigger.
DROP VIEW Statement
on
page 2-175
Drops a view.