Statement and Function Reference (Language Reference Guide)

Go Up to SQL Statement and Function Reference

The following is the reference of SQL statements and functions available in InterBase.

Each statement and function definition includes the following elements:

Element	Description
Title	Statement name
Definition	The main purpose and availability of the statement
Syntax	Diagram of the statement and its parameters
Argument	Parameters available for use with the statement
Description	Information about using the statement
Examples	Examples of using the statement in a program and in isql
See also	Where to find more information about the statement or others related to it

Most statements can be used in SQL, DSQL, and isql. In many cases, the syntax is nearly identical, except that embedded SQL statements must always be preceded by the EXEC SQL keywords. EXEC SQL is omitted from syntax statements for clarity.

In other cases there are small, but significant differences among SQL, DSQL, and isql syntax. In these cases, separate syntax statements appear under the statement heading.

A
ALTER DATABASE	ALTER DOMAIN	ALTER EXCEPTION
ALTER INDEX	ALTER PROCEDURE	ALTER TABLE
ALTER TRIGGER	ALTER USER	AVG( )
ALTER DESCRIPTION
B
BASED ON	BEGIN DECLARE SECTION
C
CASE	CAST( )	CLOSE
CLOSE (BLOB)	COALESCE( )	COMMIT
CONNECT	COUNT( )	CREATE DATABASE
CREATE DOMAIN	CREATE ENCRYPTION	CREATE EXCEPTION
CREATE GENERATOR	CREATE INDEX	CREATE JOURNAL
CREATE JOURNAL ARCHIVE	CREATE PROCEDURE	CREATE ROLE
CREATE SHADOW	CREATE SUBSCRIPTION	CREATE TABLE
CREATE TRIGGER	CREATE USER	CREATE VIEW
D
DECLARE CURSOR	DECLARE CURSOR (BLOB)	DECLARE EXTERNAL FUNCTION
DECLARE FILTER	DECLARE STATEMENT	DECLARE TABLE
DELETE	DESCRIBE	DISCONNECT
DROP DATABASE	DROP DOMAIN	DROP ENCRYPTION
DROP EXCEPTION	DROP EXTERNAL FUNCTION	DROP FILTER
DROP GENERATOR	DROP INDEX	DROP JOURNAL
DROP JOURNAL ARCHIVE	DROP PROCEDURE	DROP ROLE
DROP SHADOW	DROP SUBSCRIPTION	DROP TABLE
DROP TRIGGER	DROP USER	DROP VIEW
E
END DECLARE SECTION	EVENT INIT	EVENT WAIT
EXECUTE	EXECUTE IMMEDIATE	EXECUTE PROCEDURE
EXTRACT( )
F
FETCH	FETCH (BLOB)
G
GEN_ID( )	GRANT	GRANT SUBSCRIBE
GRANT TEMPORARY SUBSCRIBE
I
INSERT	INSERT CURSOR (BLOB)
M
MAX( )	MIN( )
N
NULLIF( )
O
OPEN	OPEN (BLOB)
P
PREPARE
R
RELEASE SAVEPOINT	REVOKE	ROLLBACK
S
SAVEPOINT	SELECT	SET DATABASE
SET GENERATOR	SET NAMES (Reference)	SET SQL DIALECT
SET STATISTICS	SET SUBSCRIPTION	SET TRANSACTION
SHOW SQL DIALECT	SHOW SUBSCRIPTION	SUM( )
T
TRUNCATE TABLE
U
UPDATE	UPPER( )
W
WHENEVER

Advance To:

• ALTER DATABASE