Subject Re: [firebird-support] Maintainance of stored procedures
Author Milan Babuskov
women_lover_best wrote:
> we have just completed our database design,and stored procedures
> also.Now,there were some issues...some columns datatypee was required
> to be changed..but Firebird is not allowing it as it says there are
> dependencies due to stored we have to drop all those
> stored procedures..

No need to drop. Just ALTER them to be empty, change the fields, and
ALTER back.

> Our database team is worried it might become
> difficult to maintain database and stored procedures..are
> their some ways to handle such scenarios?

There are admin. tools provide you with a script that does the job. So,
you just copy/paste the script and you're done.

Milan Babuskov