B Supported SQL Statements
Neoview Script supports these SQL statements, SQL utilities, and other
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