SQL Statements that DSQL Can Process

From InterBase

Go Up to Writing a DSQL Application


DSQL can process most but not all SQL statements. The following table lists SQL statement that are available to DSQL:

ALTER DATABASE

ALTER DOMAIN

ALTER EXCEPTION

ALTER INDEX

ALTER PROCEDURE

ALTER TABLE

ALTER TRIGGER

COMMIT

CONNECT

CREATE DATABASE

CREATE DOMAIN

CREATE EXCEPTION

CREATE GENERATOR

CREATE INDEX

CREATE PROCEDURE

CREATE ROLE

CREATE SHADOW

CREATE TABLE

CREATE TRIGGER

CREATE VIEW

DECLARE EXTERNAL FUNCTION

DECLARE FILTER

DELETE

DROP DATABASE

DROP DOMAIN

DROP EXCEPTION

DROP EXTERNAL FUNCTION

DROP FILTER

DROP INDEX

DROP PROCEDURE

DROP ROLE

DROP SHADOW

DROP TABLE

DROP TRIGGER

DROP VIEW

EXECUTE PROCEDURE

GRANT

INSERT

INSERT CURSOR (BLOB)

REVOKE

ROLLBACK

SELECT

SET GENERATOR

UPDATE

The following ESQL statements cannot be processed by DSQL: CLOSE, DECLARE, CURSOR, DESCRIBE, EXECUTE, EXECUTE IMMEDIATE, FETCH, OPEN, PREPARE.

The following ISQL commands cannot be processed by DSQL: BLOBDUMP, EDIT, EXIT, HELP, INPUT, OUTPUT, QUIT, SET, SET AUTODDL, SET BLOBDISPLAY, SET COUNT, SET ECHO, SET LIST, SET NAMES, SET PLAN, SET STATS, SET TERM, SET TIME, SHELL, SHOW CHECK, SHOW DATABASE, SHOW DOMAINS, SHOW EXCEPTIONS, SHOW FILTERS, SHOW FUNCTIONS, SHOW GENERATORS, SHOW GRANT, SHOW INDEX, SHOW PROCEDURES, SHOW SYSTEM, SHOW TABLES, SHOW TRIGGERS, SHOW VERSION, SHOW VIEWS.

Advance To: