Home

	Expand Search

ASA Reference Manual

Chapter 9: SQL Statements

Chapter 9

SQL Statements

About this chapter

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

Common elements in SQL syntax

Syntax conventions

Statement applicability indicators

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

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]