Switch to: V9V8V7V6V5
Table of Contents

DROP TYPE

Removes a user-defined data type.

Syntax

drop_type_statement
    :    DROP TYPE [IF EXISTS] type_name

Arguments

[IF EXISTS]

Do not raise error in case there is no type with the specified name.

type_name

The name of type to be deleted.

Examples

DROP TYPE DayOfWeek;
DROP TYPE IF EXISTS DayOfWeek;