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 Server - SQL Reference » SQL Statements

DROP SERVICE statement Next Page

DROP STATEMENT statement [ESQL]

Use this statement to free 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.

Permissions

Must have prepared the statement.

Side effects

None.

See also
Standards and compatibility
Example

The following are examples of DROP STATEMENT use:

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