>>-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--'
built-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-------------------------------------------------------------------------------------------------------'
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.