Filter
Top Products
B Supported SQL Statements
Neoview Script supports these SQL statements, SQL utilities, and other SQL-related commands.
For more information about these statements, see the Neoview SQL Reference Manual. For a list of
statements that are available only to HP support, see the Neoview Database Support Guide.
DescriptionSQL Statement
Adds or removes a materialized view to or from a
materialized view group.
ALTER MVGROUP
Alters the synonym of a specified table.ALTER SYNONYM
Adds a column to a table or renames a table.ALTER TABLE
Enables or disables triggers, individually or by SQL table.ALTER TRIGGER
Renames a view.ALTER VIEW
Starts a transaction.BEGIN WORK
Commits changes made during a transaction and ends the
transaction.
COMMIT WORK
Creates an index on a table.CREATE INDEX
Creates a materialized view.CREATE MATERIALIZED VIEW
Creates a logical collection of materialized views, such as
materialized views that are defined on a common table or
that share the same refresh frequency rate.
CREATE MVGROUP
Creates a schema.CREATE SCHEMA
Creates a synonym for a table so that queries can refer to
the synonym instead of the actual table name.
CREATE SYNONYM
Creates a table.CREATE TABLE
Creates a trigger on an SQL table. A trigger is a mechanism
that enables a database system to perform certain actions
automatically when specified events occur.
CREATE TRIGGER
Creates a view.CREATE VIEW
Creates a volatile index.CREATE VOLATILE INDEX
Creates a volatile table.CREATE VOLATILE TABLE
Deletes a row or rows from a table or an updateable view.DELETE
Deletes an index.DROP INDEX
Deletes a materialized view.DROP MATERIALIZED VIEW
Deletes a materialized view group.DROP MVGROUP
Deletes a schema.DROP SCHEMA
Deletes a synonym.DROP SYNONYM
Deletes a table and any indexes, constraints, and inactive
locks on the table.
DROP TABLE
Deletes a trigger on an SQL table.DROP TRIGGER
Deletes a view.DROP VIEW
Deletes a volatile index.DROP VOLATILE INDEX
Deletes a volatile table.DROP VOLATILE TABLE
Executes an SQL statement previously compiled by a
PREPARE statement.
EXECUTE
Grants access privileges for a table or view to specified
users.
GRANT
133