DROP { SPECIFIC FUNCTION [ database_name_1. ] specific_function_name |
FUNCTION [ database_name_2. ] function_name [ ( data_type [,...] ) ]
} [;]
- data_type
{ INTEGER | SMALLINT | BIGINT | BYTEINT | DATE |
{ TIME | TIMESTAMP } [ (fractional_seconds_precision) ] [WITH TIME ZONE] |
INTERVAL YEAR [(precision)] [TO MONTH] |
INTERVAL MONTH [(precision)] |
INTERVAL DAY [(precision)]
[TO { HOUR | MINUTE | SECOND [(fractional_seconds_precision)] }] |
INTERVAL HOUR [(precision)]
[TO { MINUTE | SECOND [(fractional_seconds_precision)] }] |
INTERVAL MINUTE [(precision)] [TO SECOND [(fractional_seconds_precision)]] |
INTERVAL SECOND [ ( precision [, fractional_seconds_precision ] ) |
PERIOD (DATE) |
PERIOD ( { TIME | TIMESTAMP } [(precision)] [WITH TIME ZONE] ) |
REAL |
DOUBLE PRECISION |
FLOAT [ (integer) ] |
NUMBER [ ( { integer | *} [, integer]... ) ] |
{ DECIMAL | NUMERIC } [ ( integer [, integer]... ) ] |
{ CHAR | BYTE | GRAPHIC } [ (integer) ] |
{ VARCHAR | CHAR VARYING | VARBYTE | VARGRAPHIC } [ (integer) ] |
LONG VARCHAR |
LONG VARGRAPHIC |
{ BINARY LARGE OBJECT | BLOB | CHARACTER LARGE OBJECT | CLOB }
( integer [ G | K | M ] ) |
[SYSUDTLIB.] { XML | XMLTYPE } [ ( integer [ G | K | M ] ) ]
[ INLINE LENGTH integer ] |
[SYSUDTLIB.] JSON [ ( integer [ K | M ] ) ] [ INLINE LENGTH integer ]
[ CHARACTER SET { UNICODE | LATIN } | STORAGE FORMAT { BSON | UBJSON } ] |
[SYSUDTLIB.] ST_GEOMETRY [ (integer [ K | M ]) ] [ INLINE LENGTH integer ] |
[SYSUDTLIB.] DATASET [ (integer [ K | M ]) ] [ INLINE LENGTH integer ]
storage_format |
[SYSUDTLIB.] { UDT_name | MBR | ARRAY_name | VARRAY_name }
}
- storage_format
STORAGE FORMAT { Avro | CSV [ CHARACTER SET { UNICODE | LATIN } ] }
[ WITH SCHEMA [database.] schema_name ]