Statement and Function Reference (Language Reference Guide)

From InterBase

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