Switch to: V12V11V10V9V8V7V6V5

Table of Contents

DROP TYPE

Removes a user-defined data type.

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;