Deleting an Oracle Database Server User-Defined Datatype
A message box displays prompting you for confirmation when you delete a user-defined datatype.
To delete a user-defined datatype:
- In the Object Navigator, click an object type, table type, or varying array
type, then choose Edit | Clear from the menu
or click Delete in the toolbar.
Or,
- Choose a type name from the Name drop-down
list in the Stored Program Unit editor, then click Drop
to delete the type.
Note:
You cannot delete a type that is referenced in another datatype, nested
object or REF object. The references must be dropped before you can delete
the type definition.
Related topics
About the Type Wizard
Creating an Oracle Database Server User-Defined Datatype
with the Type Wizard
Editing an Oracle Database Server User-Defined Datatype