To drop a object select the drop option from the database tab's right click menu.
For this example we will attempt to drop a type.
You will be prompted with a confirmation dialog that ask if you are sure. The confirmation dialog also gives you the option to view the objects dependencies.
If it has any objects that reference it with a restriction of Normal, the drop will fail.
In this case the object drop failed because a function references the type we were trying to drop.
LA not only shows the error message, but the NOTICE returned from the server letting you know the name of
the dependent object.
At this point you could use the Drop Cascade option, but that will drop the function as well. The best way would be to open the function and save it to a file,
then drop the function, then drop the type. After your type is dropped you can create a new one with your changes and then recompile the dropped
function.