SQL Anywhere Studio Help
  SQL Language Links

SQL syntax help

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

Character data types

Numeric data types

Money data types

BIT data type

Date and time data types

Binary data types

Domains

Data type conversions

Year 2000 compliance

Function types

Alphabetical list of functions

Keywords

Identifiers

Strings

Operators

Expressions

Search conditions

Special values

Variables

Comments

NULL value

Using the SQL statement reference

ALLOCATE DESCRIPTOR statement [ESQL]

ALTER DATABASE statement

ALTER DBSPACE statement

ALTER EVENT statement

ALTER FUNCTION statement

ALTER INDEX statement

ALTER PROCEDURE statement

ALTER PUBLICATION statement

ALTER REMOTE MESSAGE TYPE statement [SQL Remote]

ALTER SERVER statement

ALTER SERVICE statement

ALTER SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]

ALTER SYNCHRONIZATION USER statement [MobiLink]

ALTER TABLE statement

ALTER TRIGGER statement

ALTER VIEW statement

ALTER WRITEFILE statement

BACKUP statement

BEGIN statement

BEGIN TRANSACTION statement

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]

CREATE COMPRESSED DATABASE statement

CREATE DATABASE statement

CREATE DBSPACE statement

CREATE DECRYPTED FILE statement

CREATE DOMAIN statement

CREATE ENCRYPTED FILE statement

CREATE EVENT statement

CREATE EXISTING TABLE statement

CREATE EXTERNLOGIN statement

CREATE FUNCTION statement

CREATE INDEX statement

CREATE MESSAGE statement [T-SQL]

CREATE PROCEDURE statement

CREATE PROCEDURE statement [T-SQL]

CREATE PUBLICATION statement

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 SUBSCRIPTION statement [MobiLink]

CREATE SYNCHRONIZATION USER statement [MobiLink]

CREATE TABLE statement

CREATE TRIGGER statement

CREATE TRIGGER statement [SQL Remote]

CREATE TRIGGER statement [T-SQL]

CREATE VARIABLE statement

CREATE VIEW statement

CREATE WRITEFILE 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]

DISCONNECT statement [ESQL] [Interactive SQL]

DROP statement

DROP DATABASE statement

DROP CONNECTION statement

DROP EXTERNLOGIN statement

DROP PUBLICATION statement

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 SUBSCRIPTION statement [MobiLink]

DROP SYNCHRONIZATION USER statement [MobiLink]

DROP VARIABLE statement

EXCEPT operation

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 [SQL Remote]

HELP statement [Interactive SQL]

IF statement

IF statement [T-SQL]

INCLUDE statement [ESQL]

INPUT statement [Interactive SQL]

INSERT statement

INSTALL JAVA statement

INTERSECT operation

LEAVE statement

LOAD STATISTICS statement

LOAD TABLE statement

LOCK TABLE statement

LOOP 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 [T-SQL]

READ statement [Interactive SQL]

READTEXT statement [T-SQL]

RELEASE SAVEPOINT statement

REMOTE RESET statement [SQL Remote]

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

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

START LOGGING statement [Interactive SQL]

START SUBSCRIPTION statement [SQL Remote]

START SYNCHRONIZATION DELETE statement [MobiLink]

STOP DATABASE statement

STOP ENGINE 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 TABLE statement

UNION operation

UNLOAD statement

UNLOAD TABLE statement

UPDATE statement

UPDATE (positioned) statement [ESQL] [SP]

UPDATE statement [SQL Remote]

VALIDATE INDEX statement

VALIDATE TABLE statement

WAITFOR statement

WHENEVER statement [ESQL]

WHILE statement [T-SQL]

WRITETEXT statement [T-SQL]