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.

SQL Statement

Description

 

 

ALTER MVGROUP

Adds or removes a materialized view to or from a

 

materialized view group.

 

 

ALTER SYNONYM

Alters the synonym of a specified table.

 

 

ALTER TABLE

Adds a column to a table or renames a table.

 

 

ALTER TRIGGER

Enables or disables triggers, individually or by SQL table.

 

 

ALTER VIEW

Renames a view.

 

 

BEGIN WORK

Starts a transaction.

 

 

COMMIT WORK

Commits changes made during a transaction and ends the

 

transaction.

 

 

CREATE INDEX

Creates an index on a table.

 

 

CREATE MATERIALIZED VIEW

Creates a materialized view.

 

 

CREATE MVGROUP

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 SCHEMA

Creates a schema.

 

 

CREATE SYNONYM

Creates a synonym for a table so that queries can refer to

 

the synonym instead of the actual table name.

 

 

CREATE TABLE

Creates a table.

 

 

CREATE TRIGGER

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 VIEW

Creates a view.

 

 

CREATE VOLATILE INDEX

Creates a volatile index.

 

 

CREATE VOLATILE TABLE

Creates a volatile table.

 

 

DELETE

Deletes a row or rows from a table or an updateable view.

 

 

DROP INDEX

Deletes an index.

 

 

DROP MATERIALIZED VIEW

Deletes a materialized view.

 

 

DROP MVGROUP

Deletes a materialized view group.

 

 

DROP SCHEMA

Deletes a schema.

 

 

DROP SYNONYM

Deletes a synonym.

 

 

DROP TABLE

Deletes a table and any indexes, constraints, and inactive

 

locks on the table.

 

 

DROP TRIGGER

Deletes a trigger on an SQL table.

 

 

DROP VIEW

Deletes a view.

 

 

DROP VOLATILE INDEX

Deletes a volatile index.

 

 

DROP VOLATILE TABLE

Deletes a volatile table.

 

 

EXECUTE

Executes an SQL statement previously compiled by a

 

PREPARE statement.

 

 

GRANT

Grants access privileges for a table or view to specified

 

users.

 

 

133