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 |
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