close

Description

Deactivates a cursor.

Syntax

close cursor_name

Parameters

cursor_name

is the name of the cursor to close.

Examples

Example 1

Closes the cursor named authors_crsr:

close authors_crsr

Usage

Standards

SQL92 – Compliance level: Entry-level compliant.

Permissions

close permission defaults to all users. No permission is required to use it.

See also

Commands deallocate cursor, declare cursor, fetch, open