Show Related--User-defined functions

When you select a user-defined function from the contents pane and select Show Related for that object, the Show Related dialog lists any objects with first-level dependencies on that user-defined function. The object can be: schemas. You can view second-level dependencies by selecting Show Related for each object with a first-level dependency.

Whenever a function is dropped, all privileges on the user-defined function are also dropped. Any plans or packages that are dependent on the function dropped are made inoperative. If other user-defined functions are sourced on the user-defined function being dropped, the function can not be dropped.

Schemas

When you drop a user-defined function, the schema with which it is associated remains unchanged.

Return to main Show Related help window