Syntax

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram                                 .-VALUE-.
>>-+--------+-SIGNAL-+-SQLSTATE--+-------+--+-sqlstate-string-constant-+-+-->
   '-label:-'        |                      '-sqlstate-string-variable-' |
                     '-condition-name------------------------------------'
 
>--+--------------------+--------------------------------------><
   '-signal-information-'
 
signal-information:
 
          .-,-----------------------------------------------------------.
          V                                                             |
|--+-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----'                                        |
   '-(--diagnostic-string-constant--)-------------------------------------'