Name
DROP TYPE
-- Removes a type from the system catalogs.
Synopsis
DROP TYPE typename [, ...]
Parameters
- typename
The sole parameter of this command is the name of an existing type you wish to remove.
Results
- DROP
This message is displayed if the specified type is dropped successfully.
- ERROR: RemoveType: type 'typename' does not exist
This message is displayed if the specified type is not found.
Description
Use the DROP TYPE command to remove a type from the
database system. Only the owner of a type will be allowed to remove it.
 | Warning! |
|---|
| | If you are logged in as a superuser account, you will
be able to drop system types. This can cause extreme instability. Be careful!
|
This command will not automatically remove any objects that reference the data type.
Once the data type is removed, anything that uses it will most likely stop working.
Be sure to remove these objects.
Examples
The following example demonstrates how to remove the simple type.
DROP TYPE simple;