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

SQL Anywhere 17 » SQL Anywhere Server - SQL Reference » SQL statements » Alphabetical list of SQL statements

DROP STATEMENT statement [ESQL]

Frees statement resources.

Syntax
DROP STATEMENT [ owner.]statement-name
statement-name : 
identifier 
| hostvar
Remarks

The DROP STATEMENT statement frees resources used by the named prepared statement. These resources are allocated by a successful PREPARE statement, and are normally not freed until the database connection is released.

To drop the statement, you must first have prepared the statement.

Privileges

None.

Side effects

None.

Standards
  • ANSI/ISO SQL Standard

    Not in the standard. In the ANSI/ISO SQL Standard, this functionality is provided by the DEALLOCATE PREPARE statement, which is part of the optional ANSI/ISO SQL Language Feature B032, "Extended dynamic SQL".

Example

The following are examples of DROP STATEMENT use:

EXEC SQL DROP STATEMENT S1;
EXEC SQL DROP STATEMENT :stmt;