Hi

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.

TIA
Rob

--
Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd