SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—544517-008
2-2
Data Definition Language (DDL) Statements
CREATE PROCEDURE Statement
on page 2-61
Defines an existing Java method as an SPJ and
registers it in NonStop SQL/MX.
CREATE SCHEMA Statement
on
page 2-69
Creates a schema.
CREATE SQLMP ALIAS Statement
on page 2-73
Creates mappings from logical names to physical
names for SQL/MP database objects.
CREATE TABLE Statement
on
page 2-77
Creates a table.
CREATE TRIGGER Statement
on
page 2-100
Creates a trigger.
CREATE VIEW Statement
on
page 2-109
Creates a view.
DROP CATALOG Statement
on
page 2-123
Drops an empty catalog.
DROP INDEX Statement
on
page 2-124
Drops an index.
DROP PROCEDURE Statement
on
page 2-125
Drops an SPJ and its stored procedure label from
NonStop SQL/MX.
DROP SCHEMA Statement
on
page 2-126
Drops a schema.
DROP SQL Statement
on
page 2-129
Removes NonStop SQL/MX from a local node.
DROP SQLMP ALIAS Statement
on
page 2-130
Drops mappings from logical names to physical
names for SQL/MP database objects.
DROP TABLE Statement
on
page 2-132
Drops a table.
DROP TRIGGER Statement
on
page 2-134
Drops a trigger.
DROP VIEW Statement
on
page 2-135
Drops a view.
EXPLAIN Statement
on page 2-143 Grants access privileges for a table or view to
specified users.
GRANT EXECUTE Statement
on
page 2-163
Grants access privileges for a procedure to specified
users.
INITIALIZE SQL Statement
on
page 2-166
Prepares a local node to run NonStop SQL/MX.
Creates SQL/MX user metadata (UMD) tables,
system metadata, and NonStop MXCS metadata
tables.
REVOKE Statement
on page 2-188 Revokes access privileges for a table or view from
specified users.