Drop Type

Removes a type from the system catalogs.


DROP TYPE typename [, ...]



The name of a type you wish to remove. You may drop multiple types by specifying their names in a comma-delimited list.



The message returned when a type is dropped successfully.

ERROR: RemoveType: type 'typename' does not exist

The error displayed if the type typename is not found in the connected database.


Use the DROP TYPE command to remove a type from the database system. Only the owner of a type, or a superuser, is allowed to do this.



If you are logged in as a superuser, you will be able to drop system types. However, doing so can cause extreme instability. Be careful!

The DROP TYPE command will not automatically remove any objects that reference the data type, or types, that you are dropping. Once a data type is removed, anything that uses it will most likely stop working. Be sure to remove objects that depend on types that you drop, and be sure not to drop types used by objects you wish to keep.


The following command removes the zero data type from the booktown database:

booktown=# DROP TYPE zero;

Get Practical PostgreSQL now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.