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 procedures...so 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 changes..to 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
http://www.flamerobin.org