SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
2-2
Data Definition Language (DDL) Statements
CREATE INDEX Statement on
page 2-71
Creates an index on a table.
CREATE PROCEDURE Statement
on page 2-78
Defines an existing Java method as an SPJ and
registers it in NonStop SQL/MX.
CREATE SCHEMA Statement
on
page 2-87
Creates a schema.
CREATE SQLMP ALIAS Statement
on page 2-91
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-156
Drops an empty catalog.
DROP INDEX Statement
on
page 2-157
Drops an index.
DROP PROCEDURE Statement
on
page 2-158
Drops an SPJ and its stored procedure label from
NonStop SQL/MX.
DROP SCHEMA Statement
on
page 2-159
Drops a schema.
DROP SQL Statement
on
page 2-162
Removes NonStop SQL/MX from a local node.
DROP SQLMP ALIAS Statement
on
page 2-163
Drops mappings from logical names to physical
names for SQL/MP database objects.
DROP TABLE Statement
on
page 2-165
Drops a table.
DROP TRIGGER Statement
on
page 2-167
Drops a trigger.
DROP VIEW Statement
on
page 2-168
Drops a view.
EXPLAIN Statement
on page 2-176 Grants access privileges for a table or view to
specified users.
GET ALL SECURITY_ADMINS
Statement on page 2-193
Displays the available list of security administrators.
GIVE CATALOG Statement
on
page 2-195
Transfers the ownership of catalog from one
Guardian user to another.
GIVE Object Statement
on
page 2-196
Transfers the ownership of the object from one
Guardian user to another.