GNU/Linux |
RedHat 5.2(Apollo) |
|
![]() |
drop_type(l) |
![]() |
drop type - remove a user-defined type from the system catalogs
drop type typename
This command removes a user type from the system catalogs. Only the owner of a type can remove it.
It is the user’s responsibility to remove any operators, functions, aggregates, access methods, subtypes, classes, etc. that use a deleted type.
--
--remove the box type
--
drop type box
pgintro(1), create type(l), drop operator(l).
If a built-in type is removed, the behavior of the backend is unpredictable.
![]() |
drop_type(l) | ![]() |