Switch to: V9V8V7V6V5

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

See Also