Subject Re: [firebird-support] Changing column type
Author Martijn Tonies
> >Would I modify RDB$RELATION_FIELDS?


> It would be neater to extract the view definition, delete the
> view, and recreate it later. But of course, you'll have dependencies
> on the view. the problem with modifying RDB$RELATION_FIELDS is
> that getting the value back correctly is tricky.

There are other things you can do - if the view is the only
thing that's dependant on this column, you might want to
make it "empty" (create a dummy table and re-route your
view SELECTs to that table).

But this is all tricky stuff.

Exactly why DBW doesn't do this for you yet ... :-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions