Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
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 PSQL.6 Alphabetical keyword and function index.6 ABS 2.1 .6 ACOS 2.1 .7 ALTER DATABASE .8 ALTER DATABASE BEGIN END BACKUP 2.0 .8 ALTER DOMAIN.9 ALTER EXTERNAL FUNCTION 2.0 .9 ALTER INDEX .9 ALTER PROCEDURE .10 ALTER SEQUENCE . RESTART WITH 2.0 .11 ALTER TABLE .12 ALTER TRIGGER.14 ASCII_CHAR 2.1 .14 ASCII_VAL 2.1 .16 ASIN 2.1 .17 ATAN 2.1 .18 ATAN2 2.1 .18 AVG .19 BASEDON .20 BEGIN DECLARE SECTION . 20 BIN_AND 2.1 .20 BIN_OR 2.1 .21 BIN_SHL 2.1 .22 BIN_SHR 2.1 .23 BIN_XOR 2.1 .24 BIT_LENGTH CHAR_LENGTH CHARACTER_LENGTH OCTET_LENGTH 2.0 . 24 CASE 1.5 .25 CAST .27 CEIL CEILING 2.1 .27 CLOSE . 28 CLOSE BLOB .29 COALESCE 1.5 .29 COLLATE BLOB 2.0 .30 COLLATE PSQL 2.1 .30 COMMENT 2.0 .30 COMMIT.32 CONNECT . 32 COS 2.1 .33 COSH 2.1 .33 COT 2.1 .34 COUNT .35 CREATE COLLATION 2.1 .35 CREATE DATABASE . 36 CREATE DOMAIN . 39 CREATE EXCEPTION . 40 CREATE GENERATOR . 41 ii Firebird SQL Reference Guide CREATE GLOBAL TEMPORARY TABLE 2.1 .41 CREATE INDEX .41 CREATE INDEX COMPUTED BY 2.0 .42 CREATE OR ALTER EXCEPTION 2.0 .42 CREATE OR ALTER TRIGGER PROCEDURE 1.5 .42 CREATE PROCEDURE.42 CREATE ROLE .43 CREATE SEQUENCE 2.0 .43 CREATE SHADOW .44 CREATE TABLE.45 CREATE TRIGGER.46 CREATE TRIGGER ON CONNECT 2.1 .47 CREATE TRIGGER ON DISCONNECT 2.1 .47 CREATE TRIGGER ON TRANSACTION COMMIT 2.1 .47 CREATE TRIGGER ON TRANSACTION ROLLBACK 2.1 .47 CREATE TRIGGER ON TRANSACTION START 2.1 .47 CREATE VIEW.47 CREATE VIEW with column alias 2.1 .48 CROSS JOIN 2.0 .48 CURRENT_CONNECTION 1.5 .48 CURRENT_ROLE 1.5 .49 CURRENT_TRANSACTION 1.5 .50 CURRENT_USER 1.5 .51 CURSOR FOR 2.0 .52 DATEADD 2.1 .52 DATEDIFF 2.1 .53 DECLARE CURSOR . 55 DECLARE CURSOR BLOB .55 DECLARE EXTERNAL FUNCTION .55 DECLARE FILTER .56 DECLARE STATEMENT .56 DECLARE TABLE .57 DECODE 2.1 .57 DELETE . 58 DESCRIBE
