CLOSE (Snowflake Scripting) | Snowflake Documentation (original) (raw)

Closes the specified cursor.

For more information on cursors, see Working with cursors.

See also:

DECLARE, OPEN, FETCH

Syntax¶

Where:

_cursorname_

The name of the cursor.

Usage notes¶

• After a cursor is closed, the cursor’s current row pointer is invalid. Re-opening the cursor causes the cursor to start from the beginning of the new result set.

Examples¶

For a more complete example of using a cursor, seethe introductory cursor example.

An example using a loop is included in the documentation on FOR loops.