SHOW {
[ IN XML ] JOIN INDEX [ database_name. | user_name. ] join_index_name |
MACRO [ database_name. | user_name. ] macro_name |
[ TEMPORARY ] TABLE [ database_name. | user_name. ] table_name |
ERROR TABLE FOR [ database_name. | user_name. ] data_table_name |
[ IN XML ] TABLE [ database_name. | user_name. ] error_table_name |
TRIGGER [ database_name. | user_name. ] trigger_name |
[ IN XML ] VIEW [ database_name. | user_name. ] view_name |
PROCEDURE [ database_name. | user_name. ] procedure_name |
SPECIFIC FUNCTION [ database_name. | user_name. ] specific_function_name |
FUNCTION [ database_name. | user_name. ] function_name
[ ( data_type [,...] ) ] |
storage_format SCHEMA [SYSUDTLIB.] schema_name |
FILE [ uif_database_name. | uif_user_name. ] uif_name |
CONSTRAINT constraint_name |
GLOP SET GLOP_set_name
}
- 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 |
}
- storage_format
STORAGE FORMAT { Avro | CSV [ CHARACTER SET { UNICODE | LATIN } ] }
[ WITH SCHEMA [ database. ] schema_name ]