Syntax

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram>>-+--------+-RESIGNAL------------------------------------------>
   '-label:-'
 
>--+-------------------------------------------------------------------------------+-><
   |             .-VALUE-.                                                         |
   '-+-SQLSTATE--+-------+--+-sqlstate-string-constant-+-+--+--------------------+-'
     |                      '-sqlstate-string-variable-' |  '-signal-information-'
     '-condition-name------------------------------------'
 
signal-information:
 
|--SET--+-MESSAGE_TEXT-------+-- = --+-SQL-variable-name----------+--|
        +-CONSTRAINT_CATALOG-+       +-SQL-parameter-name---------+
        +-CONSTRAINT_SCHEMA--+       '-diagnostic-string-constant-'
        +-CONSTRAINT_NAME----+
        +-CATALOG_NAME-------+
        +-SCHEMA_NAME--------+
        +-TABLE_NAME---------+
        +-COLUMN_NAME--------+
        +-CURSOR_NAME--------+
        +-CLASS_ORIGIN-------+
        '-SUBCLASS_ORIGIN----'