DROP TIME ZONE statement

Drops a time zone from the database.

Syntax

DROP TIME ZONE [ IF EXISTS ] name

Remarks

Use the IF EXISTS clause if you do not want an error returned when the DROP TIME ZONE statement attempts to remove a time zone that does not exist.

A time zone cannot be dropped if it has been set using the time_zone database option.

Privileges

You must have either the MANAGE TIME ZONE or DROP ANY OBJECT system privilege.

Side effects

Automatic commit.

Example

This example drops a fictitious time zone, MyTimeZone, from the database.

DROP TIME ZONE MyTimeZone;