Reference Manual
   CHAPTER 9. SQL Statements     

DROP STATEMENT statement [ESQL]

Function 

To free statement resources.

Syntax 

DROP STATEMENT [ owner.]statement-name

Parameters 

statement-name: identifier or host-variable

Permissions 

Must have prepared the statement.

Side effects 

None.

See also 

PREPARE statement

Description 

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.

Standards and compatibility 

• SQL/92     Vendor extension.

• Sybase     Not supported in Open Client/Open Server

Example 

• The following are examples of DROP STATEMENT use:

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