This chapter presents detailed descriptions of the SQL statements that are available to users of Adaptive Server Anywhere.
This chapter contains an alphabetical listing of SQL statements, including some that can only be used from Embedded SQL or Interactive SQL.
The chapter includes an alphabetical list of SQL statements.
Using the SQL statement reference
ALLOCATE DESCRIPTOR statement [ESQL]
ALTER DATABASE statement
ALTER DBSPACE statement
ALTER PROCEDURE statement
ALTER SERVER statement
ALTER TABLE statement
ALTER TRIGGER statement
ALTER VIEW statement
ALTER WRITEFILE statement
BACKUP statement
BEGIN... END statement
BEGIN TRANSACTION statement
CALL statement
CASE statement
CHECKPOINT statement
CLEAR statement [ISQL]
CLOSE statement [ESQL] [SP]
COMMENT statement
COMMIT statement
COMMIT TRANSACTION statement [T-SQL]
CONFIGURE statement [ISQL]
CONNECT statement [ESQL] [ISQL]
CREATE COMPRESSED DATABASE statement
CREATE DATABASE statement
CREATE DBSPACE statement
CREATE DOMAIN 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 SCHEMA statement
CREATE SERVER statement
CREATE TABLE statement
CREATE TRIGGER statement
CREATE TRIGGER statement [T-SQL]
CREATE VARIABLE statement
CREATE VIEW statement
CREATE WRITEFILE 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][ISQL]
DROP statement
DROP DATABASE statement
DROP CONNECTION statement
DROP EXTERNLOGIN statement
DROP OPTIMIZER STATISTICS statement
DROP SERVER statement
DROP STATEMENT statement [ESQL]
DROP VARIABLE statement
EXECUTE statement [ESQL]
EXECUTE statement [T-SQL]
EXECUTE IMMEDIATE statement [ESQL] [SP]
EXIT statement [ISQL]
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
HELP statement [ISQL]
IF statement
IF statement [T-SQL]
INCLUDE statement [ESQL]
INPUT statement [ISQL]
INSERT statement
INSTALL statement
LEAVE statement
LOAD TABLE statement
LOOP statement
MESSAGE statement
OPEN statement [ESQL] [SP]
OUTPUT statement [ISQL]
PARAMETERS statement [ISQL]
PREPARE statement [ESQL]
PREPARE TO COMMIT statement
PRINT statement [T-SQL]
PUT statement [ESQL] [SP]
RAISERROR statement [T-SQL]
READ statement [ISQL]
READTEXT statement [T-SQL]
RELEASE SAVEPOINT statement
REMOVE statement
RESIGNAL statement
RESTORE statement
RESUME statement
RETURN statement
REVOKE statement
ROLLBACK statement
ROLLBACK TO SAVEPOINT statement
ROLLBACK TRIGGER statement
SAVEPOINT statement
SELECT statement
SET statement
SET statement [T-SQL]
SET CONNECTION statement [ISQL][ESQL]
SET DESCRIPTOR statement [ESQL]
SET OPTION statement
SET OPTION statement [ISQL]
SET SQLCA statement [ESQL]
SETUSER statement
SIGNAL statement
START DATABASE statement [ISQL]
START ENGINE statement [ISQL]
START JAVA statement
STOP DATABASE statement [ISQL]
STOP ENGINE statement [ISQL]
STOP JAVA statement
SYSTEM statement [ISQL]
TRUNCATE TABLE statement
UNION operation
UNLOAD TABLE statement
UPDATE statement
UPDATE (positioned) statement
VALIDATE TABLE statement
WHENEVER statement [ESQL]
WHILE statement [T-SQL]
WRITETEXT statement [T-SQL]