The following list provides links into the SQL Anywhere documentation for the following topics: SQL language elements, SQL statements, data types, and functions that are available to users of SQL Anywhere.

SQL data types

Character data types

Numeric data types

Money data types

Bit array data types

Date and time data types

Binary data types

Domains

Data type conversions

Java and SQL data type conversion

SQL functions

Function types

SQL functions

SQL language elements

Keywords

Identifiers

Strings

Constants

Operators

Expressions

Search conditions

Special values

Variables

Comments

NULL value

SQL statements

Using the SQL statement reference

ALLOCATE DESCRIPTOR statement [ESQL]

ALTER DATABASE statement

ALTER DBSPACE statement

ALTER DOMAIN statement

ALTER EVENT statement

ALTER EXTERNAL ENVIRONMENT statement

ALTER FUNCTION statement

ALTER INDEX statement

ALTER LOGIN POLICY statement

ALTER MATERIALIZED VIEW statement

ALTER PROCEDURE statement

ALTER PUBLICATION statement [MobiLink] [SQL Remote]

ALTER REMOTE MESSAGE TYPE statement [SQL Remote]

ALTER SERVER statement

ALTER SERVICE statement

ALTER STATISTICS statement

ALTER SYNCHRONIZATION PROFILE statement [MobiLink]

ALTER SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]

ALTER SYNCHRONIZATION USER statement [MobiLink]

ALTER TABLE statement

ALTER TEXT CONFIGURATION statement

ALTER TEXT INDEX statement

ALTER TRIGGER statement

ALTER VIEW statement

ATTACH TRACING statement

BACKUP statement

BEGIN statement

BEGIN SNAPSHOT statement

BEGIN TRANSACTION statement [T-SQL]

BREAK statement [T-SQL]

CALL statement

CASE statement

CHECKPOINT statement

CLEAR statement [Interactive SQL]

CLOSE statement [ESQL] [SP]

COMMENT statement

COMMIT statement

CONFIGURE statement [Interactive SQL]

CONNECT statement [ESQL] [Interactive SQL]

CONTINUE statement [T-SQL]

CREATE DATABASE statement

CREATE DBSPACE statement

CREATE DECRYPTED DATABASE statement

CREATE DECRYPTED FILE statement

CREATE DOMAIN statement

CREATE ENCRYPTED DATABASE statement

CREATE ENCRYPTED FILE statement

CREATE EVENT statement

CREATE EXISTING TABLE statement

CREATE EXTERNLOGIN statement

CREATE FUNCTION statement (web services)

CREATE INDEX statement

CREATE LOCAL TEMPORARY TABLE statement

CREATE LOGIN POLICY statement

CREATE MATERIALIZED VIEW statement

CREATE MESSAGE statement [T-SQL]

CREATE PROCEDURE statement

CREATE PROCEDURE statement [T-SQL]

CREATE PROCEDURE statement (external procedures)

CREATE PROCEDURE statement (web services)

CREATE PROCEDURE statement [T-SQL]

CREATE PUBLICATION statement [MobiLink] [SQL Remote]

CREATE REMOTE MESSAGE TYPE statement [SQL Remote]

CREATE SCHEMA statement

CREATE SERVER statement

CREATE SERVICE statement

CREATE STATISTICS statement

CREATE SUBSCRIPTION statement [SQL Remote]

CREATE SYNCHRONIZATION PROFILE statement [MobiLink]

CREATE SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]

CREATE SYNCHRONIZATION USER statement [MobiLink]

CREATE TABLE statement

CREATE TEXT CONFIGURATION statement

CREATE TEXT INDEX statement

CREATE TRIGGER statement

CREATE TRIGGER statement [T-SQL]

CREATE VARIABLE statement

CREATE USER statement

CREATE VIEW statement

DEALLOCATE statement

DEALLOCATE DESCRIPTOR statement [ESQL]

Declaration section [ESQL]

DECLARE statement

DECLARE CURSOR statement [ESQL] [SP]

DECLARE CURSOR statement [T-SQL]

DECLARE LOCAL TEMPORARY TABLE statement

DELETE statement

DELETE (positioned) statement [ESQL] [SP]

DESCRIBE statement [ESQL]

DESCRIBE statement [Interactive SQL]

DETACH TRACING statement

DISCONNECT statement [ESQL] [Interactive SQL]

DROP CONNECTION statement

DROP DATABASE statement

DROP DATATYPE statement

DROP DBSPACE statement

DROP DOMAIN statement

DROP EVENT statement

DROP EXTERNLOGIN statement

DROP FUNCTION statement

DROP INDEX statement

DROP LOGIN POLICY statement

DROP MATERIALIZED VIEW statement

DROP MESSAGE statement

DROP PROCEDURE statement

DROP PUBLICATION statement [MobiLink] [SQL Remote]

DROP REMOTE MESSAGE TYPE statement [SQL Remote]

DROP SERVER statement

DROP SERVICE statement

DROP STATEMENT statement [ESQL]

DROP STATISTICS statement

DROP SUBSCRIPTION statement [SQL Remote]

DROP SYNCHRONIZATION PROFILE statement [MobiLink]

DROP SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]

DROP SYNCHRONIZATION USER statement [MobiLink]

DROP TABLE statement

DROP TEXT CONFIGURATION statement

DROP TEXT INDEX statement

DROP TRIGGER statement

DROP USER statement

DROP VARIABLE statement

DROP VIEW statement

EXCEPT clause

EXECUTE statement [ESQL]

EXECUTE statement [T-SQL]

EXECUTE IMMEDIATE statement [SP]

EXIT statement [Interactive SQL]

EXPLAIN statement [ESQL]

FETCH statement [ESQL] [SP]

FOR statement

FORWARD TO statement

FROM clause

GET DATA statement [ESQL]

GET DESCRIPTOR statement [ESQL]

GET OPTION statement [ESQL]

GOTO statement [T-SQL]

GRANT statement

GRANT CONSOLIDATE statement [SQL Remote]

GRANT PUBLISH statement [SQL Remote]

GRANT REMOTE statement [SQL Remote]

GRANT REMOTE DBA statement [MobiLink] [SQL Remote]

GROUP BY clause

HELP statement [Interactive SQL]

IF statement

IF statement [T-SQL]

INCLUDE statement [ESQL]

INPUT statement [Interactive SQL]

INSERT statement

INSTALL EXTERNAL OBJECT statement

INSTALL JAVA statement

INTERSECT clause

LEAVE statement

LOAD STATISTICS statement

LOAD TABLE statement

LOCK TABLE statement

LOOP statement

MERGE statement

MESSAGE statement

OPEN statement [ESQL] [SP]

OUTPUT statement [Interactive SQL]

PARAMETERS statement [Interactive SQL]

PASSTHROUGH statement [SQL Remote]

PREPARE statement [ESQL]

PREPARE TO COMMIT statement

PRINT statement [T-SQL]

PUT statement [ESQL]

RAISERROR statement

READ statement [Interactive SQL]

READTEXT statement [T-SQL]

REFRESH MATERIALIZED VIEW statement

REFRESH TEXT INDEX statement

REFRESH TRACING LEVEL statement

RELEASE SAVEPOINT statement

REMOTE RESET statement [SQL Remote]

REMOVE EXTERNAL OBJECT statement

REMOVE JAVA statement

REORGANIZE TABLE statement

RESIGNAL statement

RESTORE DATABASE statement

RESUME statement

RETURN statement

REVOKE statement

REVOKE CONSOLIDATE statement [SQL Remote]

REVOKE PUBLISH statement [SQL Remote]

REVOKE REMOTE statement [SQL Remote]

REVOKE REMOTE DBA statement [SQL Remote]

ROLLBACK statement

ROLLBACK TO SAVEPOINT statement

ROLLBACK TRANSACTION statement [T-SQL]

ROLLBACK TRIGGER statement

SAVE TRANSACTION statement [T-SQL]

SAVEPOINT statement

SELECT statement

SET statement

SET statement [T-SQL]

SET CONNECTION statement [Interactive SQL] [ESQL]

SET DESCRIPTOR statement [ESQL]

SET OPTION statement

SET OPTION statement [Interactive SQL]

SET REMOTE OPTION statement [SQL Remote]

SET SQLCA statement [ESQL]

SETUSER statement

SIGNAL statement

START DATABASE statement

START ENGINE statement [Interactive SQL]

START EXTERNAL ENVIRONMENT statement

START JAVA statement

START LOGGING statement [Interactive SQL]

START SUBSCRIPTION statement [SQL Remote]

START SYNCHRONIZATION DELETE statement [MobiLink]

STOP DATABASE statement

STOP ENGINE statement

STOP EXTERNAL ENVIRONMENT statement

STOP JAVA statement

STOP LOGGING statement [Interactive SQL]

STOP SUBSCRIPTION statement [SQL Remote]

STOP SYNCHRONIZATION DELETE statement [MobiLink]

SYNCHRONIZE SUBSCRIPTION statement [SQL Remote]

SYSTEM statement [Interactive SQL]

TRIGGER EVENT statement

TRUNCATE statement

TRUNCATE TEXT INDEX statement

UNION clause

UNLOAD statement

UPDATE statement

UPDATE (positioned) statement [ESQL] [SP]

UPDATE statement [SQL Remote]

VALIDATE statement

WAITFOR statement

WHENEVER statement [ESQL]

WHILE statement [T-SQL]

WINDOW clause

WRITETEXT statement [T-SQL]