Table of Contents
SHOW TYPES
SHOW TYPES statement lists user defined TYPES in the database.
Syntax
SHOW TYPES [{FROM|OF} db_name]
Examples
SHOW TYPES;
Result Columns
fld_id
The ID of type.
fld_basetype_name
The name of base (parent) type if it exists. NULL otherwise.
fld_derived_types_id
The list of types that are derived from this type. NULL if such types do not exist.
fld_category
The category of this type.
fld_type_name
The name of type.
fld_instaniable
TRUE if this type can be used as a base type.
fld_final
TRUE if this type cannot be a base type.
fld_default_value
The default value for this type.
fld_specific_info
This column may contains additional information specific to type. For example ENUM type returns here list of String constants, which can use some GUI app to build menu of choices.
Example
For CREATE TYPE DayOfWeek AS ENUM8( 'Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday' );
SHOW TYPES will return
