Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Context-Sensitive Help » SQL Language Links

SQL Language Links Next Page

SQL syntax help


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

Introduction to SQL functions

Function types

Alphabetical list of 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 FUNCTION statement

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

ALTER SYNCHRONIZATION USER statement [MobiLink]

ALTER TABLE statement

ALTER TRIGGER statement

ALTER VIEW statement

ATTACH TRACING statement

BACKUP statement

BEGIN 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 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 LOCAL TEMPORARY TABLE statement

CREATE MATERIALIZED VIEW statement

CREATE MESSAGE statement [T-SQL]

CREATE PROCEDURE statement

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

CREATE SYNCHRONIZATION USER statement [MobiLink]

CREATE TABLE statement

CREATE TRIGGER statement

CREATE TRIGGER statement [T-SQL]

CREATE VARIABLE 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 statement

DROP CONNECTION statement

DROP DATABASE statement

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

DROP SYNCHRONIZATION USER statement [MobiLink]

DROP VARIABLE statement

EXCEPT statement

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

INTERSECT statement

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]

REFRESH MATERIALIZED VIEW statement

REFRESH TRACING LEVEL statement

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

UNLOAD statement

UNLOAD TABLE 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]