Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 8.5 Dropping an Object Type
Postgres Plus Advanced Server Oracle Compatibility Developer's Guide
8.5 Dropping an Object Type
The syntax for deleting an object type is as follows.
DROP TYPE objtype;
objtype is the identifier of the object type to be dropped. If the definition of objtype contains attributes that are themselves object types, these nested object types must be dropped last.
The following example drops the emp_obj_typ and the addr_obj_typ object types created earlier in this chapter. emp_obj_typ must be dropped first since it contains addr_obj_typ within its definition as an attribute.
DROP TYPE emp_obj_typ; DROP TYPE addr_obj_typ;