SQL syntax help

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

SQL functions

SQL language elements

SQL statements

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

ALTER PROCEDURE statement

ALTER PUBLICATION statement [MobiLink] [SQL Remote]

ALTER REMOTE MESSAGE TYPE statement [SQL Remote]

ALTER SEQUENCE statement

ALTER SERVER statement

ALTER SERVICE statement [HTTP web service]

ALTER SERVICE statement [SOAP web service]

ALTER SPATIAL REFERENCE SYSTEM 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 USER statement

ALTER VIEW statement

ATTACH TRACING statement

BACKUP statement

BEGIN SNAPSHOT statement

BEGIN statement

BEGIN statement [TSQL]

BEGIN TRANSACTION statement [T-SQL]

BREAK statement [T-SQL]

CASE statement [T-SQL]

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

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 [External call]

CREATE FUNCTION statement [Web service]

CREATE FUNCTION statement

CREATE INDEX statement

CREATE LOCAL TEMPORARY TABLE statement

CREATE LOGIN POLICY statement

CREATE MATERIALIZED VIEW statement

CREATE MESSAGE statement [T-SQL]

CREATE MIRROR SERVER statement

CREATE PROCEDURE statement [External call]

CREATE PROCEDURE statement [Web service]

CREATE PROCEDURE statement [T-SQL]

CREATE PROCEDURE statement

CREATE PUBLICATION statement [MobiLink] [SQL Remote]

CREATE REMOTE MESSAGE TYPE statement [SQL Remote]

CREATE SCHEMA statement

CREATE SEQUENCE statement

CREATE SERVER statement

CREATE SERVICE statement [HTTP web service]

CREATE SERVICE statement [SOAP web service]

CREATE SPATIAL REFERENCE SYSTEM statement

CREATE SPATIAL UNIT OF MEASURE 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 USER statement

CREATE VARIABLE statement

CREATE VIEW statement

DEALLOCATE DESCRIPTOR statement [ESQL]

DEALLOCATE statement

Declaration section [ESQL]

DECLARE CURSOR statement [ESQL] [SP]

DECLARE LOCAL TEMPORARY TABLE statement

DECLARE statement

DELETE statement (positioned) [ESQL] [SP]

DELETE statement

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

DROP PROCEDURE statement

DROP PUBLICATION statement [MobiLink] [SQL Remote]

DROP REMOTE MESSAGE TYPE statement [SQL Remote]

DROP SEQUENCE statement

DROP SERVER statement

DROP SERVICE statement

DROP SPATIAL REFERENCE SYSTEM statement

DROP SPATIAL UNIT OF MEASURE 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 statement

EXECUTE IMMEDIATE statement [SP]

EXECUTE statement [ESQL]

EXECUTE statement [T-SQL]

EXIT statement [Interactive SQL]

EXPLAIN statement [ESQL]

FETCH statement [ESQL] [SP]

FORWARD TO statement

GET DATA statement [ESQL]

GET DESCRIPTOR statement [ESQL]

GET OPTION statement [ESQL]

GOTO statement [T-SQL]

GRANT CONSOLIDATE statement [SQL Remote]

GRANT PUBLISH statement [SQL Remote]

GRANT REMOTE DBA statement [MobiLink] [SQL Remote]

GRANT REMOTE statement [SQL Remote]

GRANT statement

GROUP BY clause

HELP statement [Interactive SQL]

IF statement [T-SQL]

INCLUDE statement [ESQL]

INPUT statement [Interactive SQL]

INSERT statement

INSTALL EXTERNAL OBJECT statement

INSTALL JAVA statement

INTERSECT statement

LEAVE statement

LOAD STATISTICS statement

LOAD TABLE statement

LOCK FEATURE statement

LOCK TABLE 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 [SP]

RESTORE DATABASE statement

RESUME statement

RETURN statement

REVOKE CONSOLIDATE statement [SQL Remote]

REVOKE PUBLISH statement [SQL Remote]

REVOKE REMOTE DBA statement [SQL Remote]

REVOKE REMOTE statement [SQL Remote]

REVOKE statement

ROLLBACK statement

ROLLBACK TO SAVEPOINT statement

ROLLBACK TRANSACTION statement [T-SQL]

ROLLBACK TRIGGER statement

SAVE TRANSACTION statement [T-SQL]

SAVEPOINT statement

SELECT statement

SET CONNECTION statement [Interactive SQL] [ESQL]

SET DESCRIPTOR statement [ESQL]

SET MIRROR OPTION statement

SET OPTION statement

SET OPTION statement [Interactive SQL]

SET REMOTE OPTION statement [SQL Remote]

SET SQLCA statement [ESQL]

SET statement [T-SQL]

SETUSER statement

SIGNAL statement [SP]

START DATABASE statement

START SERVER 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]

START SYNCHRONIZATION SCHEMA CHANGE statement [MobiLink]

STOP DATABASE statement

STOP EXTERNAL ENVIRONMENT statement

STOP JAVA statement

STOP LOGGING statement [Interactive SQL]

STOP SERVER statement

STOP SUBSCRIPTION statement [SQL Remote]

STOP SYNCHRONIZATION DELETE statement [MobiLink]

SYNCHRONIZE statement [MobiLink]

STOP SYNCHRONIZATION SCHEMA CHANGE statement [MobiLink]

SYNCHRONIZE SUBSCRIPTION statement [SQL Remote]

SYSTEM statement [Interactive SQL]

TRIGGER EVENT statement

TRUNCATE statement

TRUNCATE TEXT INDEX statement

UNION statement

UNLOAD statement

UPDATE (positioned) statement [ESQL] [SP]

UPDATE statement [SQL Remote]

UPDATE statement

VALIDATE statement

WAITFOR statement

WHENEVER statement [ESQL]

WHILE statement [T-SQL]

WRITETEXT statement [T-SQL]

UltraLite SQL statements

Discuss this page in DocCommentXchange.

Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1