|
With the Type Editor you can create, alter and drop object types. It depends on the database system that you're using how an object type is defined. If you add a Type, any opened Table Editor will add these types to it's type drop down box. So you can quickly create a new type while creating a table.
The Oracle Type Editor
As you can see in the above screenshot, the Oracle Type Editor comes with a "Specification" and an optional "Body". If the type has methods, it needs to have a Body. In the source, the name of the object will be replaced, as the text says. You have to keep this text intact.
See also: Object Template Editor
In the Database Navigator, object types will be listed with optional methods and attributes.
An Oracle Object Type with both Attributes and Methods
The above Object Type as listed in the Database Navigator.
