SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-2
Data Definition Language (DDL) Statements
CREATE SQLMP ALIAS Statement
on page 2-71
Creates mappings from logical names to physical
names for SQL/MP database objects.
CREATE TABLE Statement
on
page 2-75
Creates a table.
CREATE TRIGGER Statement
on
page 2-96
Creates a trigger.
CREATE VIEW Statement
on
page 2-105
Creates a view.
DROP CATALOG Statement
on
page 2-119
Drops an empty catalog.
DROP INDEX Statement
on
page 2-120
Drops an index.
DROP PROCEDURE Statement
on
page 2-122
Drops an SPJ and its stored procedure label from
NonStop SQL/MX.
DROP SCHEMA Statement
on
page 2-124
Drops a schema.
DROP SQL Statement
on
page 2-127
Removes NonStop SQL/MX from a local node.
DROP SQLMP ALIAS Statement
on
page 2-128
Drops mappings from logical names to physical
names for SQL/MP database objects.
DROP TABLE Statement
on
page 2-130
Drops a table.
DROP TRIGGER Statement
on
page 2-132
Drops a trigger.
DROP VIEW Statement
on
page 2-133
Drops a view.
GRANT Statement
on page 2-141 Grants access privileges for a table or view to
specified users.
GRANT EXECUTE Statement
on
page 2-145
Grants access privileges for a procedure to specified
users.
INITIALIZE SQL Statement
on
page 2-148
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-170 Revokes access privileges for a table or view from
specified users.