ISQL (or Interactive SQL) is a command line tool that is included in the Firebird distribution. It allows access to (almost) the full feature set available in Firebird, and is the recommended tool to narrow down the source of a potential problem with a SQL command should you find one. Unlike most other connectivity components and tools, ISQL shows also warning messages that may not be shown | Firebird SQL Reference Guide The complete reference of all SQL keywords and commands supported by Firebird Members of the Firebird Documentation project December 2007 Table of Contents Introduction .6 DSQL .6 ESQL .6 ISQL .6 Alphabetical keyword and function ABS .6 ACOS .7 ALTER DATABASE .8 ALTER DATABASE BEGIN END BACKUP .8 ALTER ALTER EXTERNAL FUNCTION .9 ALTER INDEX .9 ALTER PROCEDURE .10 ALTER SEQUENCE . RESTART WITH .11 ALTER TABLE .12 ALTER ASCII_CHAR .14 ASCII_VAL .16 ASIN .17 ATAN .18 ATAN2 .18 AVG .19 BASEDON .20 BEGIN DECLARE SECTION . 20 BIN_AND .20 BIN_OR .21 BIN_SHL .22 BIN_SHR .23 BIN_XOR .24 BIT_LENGTH CHAR_LENGTH CHARACTER_LENGTH OCTET_LENGTH . 24 CASE .25 CAST .27 CEIL CEILING .27 CLOSE . 28 CLOSE BLOB .29 COALESCE .29 COLLATE BLOB .30 COLLATE PSQL .30 COMMENT .30 CONNECT . 32 COS .33 COSH .33 COT .34 COUNT .35 CREATE COLLATION .35 CREATE DATABASE . 36 CREATE DOMAIN . 39 CREATE EXCEPTION . 40 CREATE GENERATOR . 41 ii Firebird SQL Reference Guide CREATE GLOBAL TEMPORARY TABLE .41 CREATE INDEX .41 CREATE INDEX COMPUTED BY .42 CREATE OR ALTER EXCEPTION .42 CREATE OR ALTER TRIGGER PROCEDURE .42 CREATE CREATE ROLE .43 CREATE SEQUENCE .43 CREATE SHADOW .44 CREATE CREATE CREATE TRIGGER ON CONNECT .47 CREATE TRIGGER ON DISCONNECT .47 CREATE TRIGGER ON TRANSACTION COMMIT .47 CREATE TRIGGER ON TRANSACTION ROLLBACK .47 CREATE TRIGGER ON TRANSACTION START .47 CREATE CREATE VIEW with column alias .48 CROSS JOIN .48 CURRENT_CONNECTION .48 CURRENT_ROLE .49 CURRENT_TRANSACTION .50 CURRENT_USER .51 CURSOR FOR .52 DATEADD .52 DATEDIFF .53 DECLARE CURSOR . 55 DECLARE CURSOR BLOB .55 DECLARE EXTERNAL FUNCTION .55 DECLARE FILTER .56 DECLARE STATEMENT .56 DECLARE TABLE .57 DECODE .57 DELETE . 58 DESCRIBE
