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.

Topics

• ALTER DATABASE
• ALTER DOMAIN
• ALTER EXCEPTION
• ALTER INDEX
• ALTER PROCEDURE
• ALTER TABLE
• ALTER TRIGGER
• ALTER USER
• AVG( )
• BASED ON
• BEGIN DECLARE SECTION
• 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
• 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
• END DECLARE SECTION
• EVENT INIT
• EVENT WAIT
• EXECUTE
• EXECUTE IMMEDIATE
• EXECUTE PROCEDURE
• EXTRACT( )
• FETCH
• FETCH (BLOB)
• GEN_ID( )
• GRANT
• GRANT SUBSCRIBE
• GRANT TEMPORARY SUBSCRIBE
• INSERT
• INSERT CURSOR (BLOB)
• MAX( )
• MIN( )
• NULLIF( )
• OPEN
• OPEN (BLOB)
• PREPARE
• RELEASE SAVEPOINT
• REVOKE
• ROLLBACK
• SAVEPOINT
• SELECT
• SET DATABASE
• SET GENERATOR
• SET NAMES (Reference)
• SET SQL DIALECT
• SET STATISTICS
• SET SUBSCRIPTION
• SET TRANSACTION
• SHOW SQL DIALECT
• SUM( )
• UPDATE
• UPPER( )
• WHENEVER