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 .