Subject Detecting dependancies
Author Robert martin

We have an issue where clients can add their own custom fields to our
database (any data type). They can also edit these field types, say
changing from 10 to 15 chars.

We have a problem where the alteration process causes an error due to a
stored procedure (and probably a view) that is based on the particular
field exists. Is there a way to

a) Detect a dependency and not alter the field.
b) Easily disable a stored procedure and later re-enable.


Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496

Wild Software Ltd