Syntax

Click to skip syntax diagram

Read syntax diagramSkip visual syntax diagram                    .-VALUE-.
>>-SIGNAL-SQLSTATE--+-------+--+-sqlstate-string-constant-+----->
                               '-sqlstate-string-variable-'
 
>--+--------------------+--------------------------------------><
   '-signal-information-'
 
signal-information:
 
        .-,-----------------------------------------------------------.
        V                                                             |
|--SET----+-MESSAGE_TEXT-------+-- = --+-variable-------------------+-+--|
          +-CONSTRAINT_CATALOG-+       '-diagnostic-string-constant-'
          +-CONSTRAINT_SCHEMA--+
          +-CONSTRAINT_NAME----+
          +-CATALOG_NAME-------+
          +-SCHEMA_NAME--------+
          +-TABLE_NAME---------+
          +-COLUMN_NAME--------+
          +-CURSOR_NAME--------+
          +-CLASS_ORIGIN-------+
          '-SUBCLASS_ORIGIN----'