DROP TYPE v16
DROP TYPE — Remove a type definition.
DROP TYPE removes the type definition. To execute this command, you must be a superuser or the owner of the type.
BODY qualifier applies only to object type definitions, not to collection types or to composite types. If you specify
BODY, only the object type body is removed and not the object type specification. If you omit
BODY, both the object type specification and body are removed.
The type isn't deleted if other database objects depend on the named type.
The name of a type definition to remove.
Drop the object type named
Drop the nested table type named