SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-2
Data Definition Language (DDL) Statements
CREATE SQLMP ALIAS Statement
on page 2-70
Creates mappings from logical names to physical
names for SQL/MP database objects.
CREATE TABLE Statement
on
page 2-74
Creates a table.
CREATE TRIGGER Statement
on
page 2-95
Creates a trigger.
CREATE VIEW Statement
on
page 2-104
Creates a view.
DROP CATALOG Statement
on
page 2-118
Drops an empty catalog.
DROP INDEX Statement
on
page 2-119
Drops an index.
DROP PROCEDURE Statement
on
page 2-120
Drops an SPJ and its stored procedure label from
NonStop SQL/MX.
DROP SCHEMA Statement
on
page 2-121
Drops a schema.
DROP SQL Statement
on
page 2-124
Removes NonStop SQL/MX from a local node.
DROP SQLMP ALIAS Statement
on
page 2-125
Drops mappings from logical names to physical
names for SQL/MP database objects.
DROP TABLE Statement
on
page 2-127
Drops a table.
DROP TRIGGER Statement
on
page 2-129
Drops a trigger.
DROP VIEW Statement
on
page 2-130
Drops a view.
GRANT Statement
on page 2-138 Grants access privileges for a table or view to
specified users.
GRANT EXECUTE Statement
on
page 2-141
Grants access privileges for a procedure to specified
users.
INITIALIZE SQL Statement
on
page 2-144
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-166 Revokes access privileges for a table or view from
specified users.