SQL Statements › CREATE PROCEDURE › CREATE PROCEDURE Syntax and Description › LEAVE Statement

LEAVE Statement

The LEAVE statement in a compound statement specifies that you want to exit the specified statement, which must contain the LEAVE statement.

Following is the syntax for the LEAVE statement:

►►─ LEAVE ─ statement-label ──────────────────────────────────────────────────►◄

statement-label

The statement-label specifies the start-label of the statement that you want to exit.