Syntax

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram>>-DROP--+-ALIAS--alias-name---------------------------------------------------+-><
         | .-DISTINCT-.                                                        |
         +-+----------+--TYPE--distinct-type-name--+----------+----------------+
         |                                         +-RESTRICT-+                |
         |                                         '-CASCADE--'                |
         +-+-+-FUNCTION-+--function-name--+------------------------------+-+---+
         | | '-ROUTINE--'                 '-(--+--------------------+--)-' |   |
         | |                                   | .-,--------------. |      |   |
         | |                                   | V                | |      |   |
         | |                                   '---parameter-type-+-'      |   |
         | '-SPECIFIC--+-FUNCTION-+--specific-name-------------------------'   |
         |             '-ROUTINE--'                                            |
         +-INDEX--index-name---------------------------------------------------+
         +-PACKAGE--package-name--+-------------------------+------------------+
         |                        | .-VERSION-.             |                  |
         |                        '-+---------+--version-id-'                  |
         +-+-+-PROCEDURE-+--procedure-name--+------------------------------+-+-+
         | | '-ROUTINE---'                  '-(--+--------------------+--)-' | |
         | |                                     | .-,--------------. |      | |
         | |                                     | V                | |      | |
         | |                                     '---parameter-type-+-'      | |
         | '-SPECIFIC--+-PROCEDURE-+--specific-name--------------------------' |
         |             '-ROUTINE---'                                           |
         +-SCHEMA--schema-name--+----------+-----------------------------------+
         |                      +-RESTRICT-+                                   |
         |                      '-CASCADE--'                                   |
         |                          .-RESTRICT-.                               |
         +-SEQUENCE--sequence-name--+----------+-------------------------------+
         +-TABLE--table-name--+----------+-------------------------------------+
         |                    +-RESTRICT-+                                     |
         |                    '-CASCADE--'                                     |
         +-TRIGGER--trigger-name-----------------------------------------------+
         '-VIEW--view-name--+----------+---------------------------------------'
                            +-RESTRICT-+
                            '-CASCADE--'
 
Read syntax diagramSkip visual syntax diagramparameter-type:
 
|----data-type--+------------+----------------------------------|
                '-AS LOCATOR-'
 
Read syntax diagramSkip visual syntax diagramdata-type:
 
|--+-built-in-type------+---------------------------------------|
   '-distinct-type-name-'
 
Read syntax diagramSkip visual syntax diagrambuilt-in-type:
 
|--+-+---SMALLINT---+----------------------------------------------------------------------------------------------+--|
   | +-+-INTEGER-+--+                                                                                              |
   | | '-INT-----'  |                                                                                              |
   | '---BIGINT-----'                                                                                              |
   |                  .-(5,0)----------------------------.                                                         |
   +-+-+-DECIMAL-+-+--+----------------------------------+---------------------------------------------------------+
   | | '-DEC-----' |  '-(--+------------------------+--)-'                                                         |
   | '-NUMERIC-----'       '-integer--+-----------+-'                                                              |
   |                                  '-, integer-'                                                                |
   |          .-(53)----------.                                                                                    |
   +-+-FLOAT--+---------------+-+----------------------------------------------------------------------------------+
   | |        '-(--integer--)-' |                                                                                  |
   | +-REAL---------------------+                                                                                  |
   | |         .-PRECISION-.    |                                                                                  |
   | '-DOUBLE--+-----------+----'                                                                                  |
   |                    .-(1)---------------.                                                                      |
   +-+-+-+-CHARACTER-+--+-------------------+--------------+--+----------------+---------------------------------+-+
   | | | '-CHAR------'  '-(--+---------+--)-'              |  +-FOR BIT DATA---+                                 | |
   | | |                     '-integer-'                   |  +-FOR SBCS DATA--+                                 | |
   | | '---+-+-CHARACTER-+--VARYING-+--(--+---------+--)---'  +-FOR MIXED DATA-+                                 | |
   | |     | '-CHAR------'          |     '-integer-'         '-CCSID--integer-'                                 | |
   | |     '-VARCHAR----------------'                                                                            | |
   | |                                          .-(1M)---------------------.                                     | |
   | '-----+-+-CHARACTER-+--LARGE OBJECT-+------+--------------------------+--+----------------+--+------------+-' |
   |       | '-CHAR------'               |      '-(--+---------+--+---+--)-'  +-FOR SBCS DATA--+  '-AS LOCATOR-'   |
   |       '-CLOB------------------------'           '-integer-'  +-K-+       +-FOR MIXED DATA-+                   |
   |                                                              +-M-+       '-CCSID--integer-'                   |
   |                                                              '-G-'                                            |
   |                  .-(1)---------------.                                                                        |
   +-+-+---GRAPHIC----+-------------------+---------+--+----------------+-----------+------------------------------+
   | | |              '-(--+---------+--)-'         |  '-CCSID--integer-'           |                              |
   | | |                   '-integer-'              |                               |                              |
   | | '---+-VARGRAPHIC------+--(--+---------+--)---'                               |                              |
   | |     '-GRAPHIC VARYING-'     '-integer-'                                      |                              |
   | |             .-(1M)---------------------.                                     |                              |
   | '---DBCLOB----+--------------------------+--+----------------+--+------------+-'                              |
   |               '-(--+---------+--+---+--)-'  '-CCSID--integer-'  '-AS LOCATOR-'                                |
   |                    '-integer-'  +-K-+                                                                         |
   |                                 +-M-+                                                                         |
   |                                 '-G-'                                                                         |
   |             .-(1)---------------.                                                                             |
   +-+-+-BINARY--+-------------------+---------+---------------------------------+---------------------------------+
   | | |         '-(--+---------+--)-'         |                                 |                                 |
   | | |              '-integer-'              |                                 |                                 |
   | | '-+-BINARY VARYING-+--(--+---------+--)-'                                 |                                 |
   | |   '-VARBINARY------'     '-integer-'                                      |                                 |
   | |                              .-(1M)---------------------.                 |                                 |
   | '---+-BLOB----------------+----+--------------------------+--+------------+-'                                 |
   |     '-BINARY LARGE OBJECT-'    '-(--+---------+--+---+--)-'  '-AS LOCATOR-'                                   |
   |                                     '-integer-'  +-K-+                                                        |
   |                                                  +-M-+                                                        |
   |                                                  '-G-'                                                        |
   +-+---DATE-----------------+------------------------------------------------------------------------------------+
   | |       .-(--0--)-.      |                                                                                    |
   | +-TIME--+---------+------+                                                                                    |
   | |            .-(--6--)-. |                                                                                    |
   | '-TIMESTAMP--+---------+-'                                                                                    |
   |             .-(200)-------------.                                                                             |
   +---DATALINK--+-------------------+--+----------------+---------------------------------------------------------+
   |             '-(--+---------+--)-'  '-CCSID--integer-'                                                         |
   |                  '-integer-'                                                                                  |
   '---ROWID-------------------------------------------------------------------------------------------------------'