DROP STATEMENT Statement [ESQL]

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.

Quick Links:

Go to Parameters

Go to Examples

Go to Standards

Go to Permissions

Syntax

DROP STATEMENT [ owner.]statement-name

Parameters

(back to top)

statement-name – identifier or host-variable

Examples

(back to top)

Example 1 – drops the statements s1 and stmt:
```
EXEC SQL DROP STATEMENT S1;
EXEC SQL DROP STATEMENT :stmt;
```

Standards

(back to top)

SQL—Vendor extension to ISO/ANSI SQL grammar.
SAP Sybase Database product—Not supported in Open Client/Open Server

Permissions

(back to top)

Must have prepared the statement.