> > I have to add an field into view. According to the LangRef (IB6) there
> > is no ALTER VIEW statement. In the FB1.5 ReleaseNotes (I'm using
> > FB1.5) there is RECREATE VIEW statement but it seems to be just
> > shortcut to avoid typing DROP VIEW? Ie it can't recreate view which is
> > used by an SP, I have to drop the SP before I can recreate the view?
> > If so then this is a major PITA... :(
> > Or is there any other way to add field into view?

Database Workbench can do this by some careful system table updates.

Download a trial at www.upscene.com

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com