Subject RE: [firebird-support] Changing column type
Author Rick DeBay
DBW updates, as far as I can tell, using standard DDL. It was what I
was using when I got the error.
I was hoping to avoid the massive recreate :-)

-----Original Message-----
From: Milan Babuskov [mailto:milanb@...]
Sent: Wednesday, October 13, 2004 2:38 PM
Subject: Re: [firebird-support] Changing column type

Rick DeBay wrote:
> I need to change a column from varchar to decimal. Is there a simple
> way to do this?

> Dropping and reading the column would be VERY difficult, as there are
> dozens of views and SP that depend on that column, either directly or
> indirectly.

You could update the system tables. It's a little be tricky but doable.
There are tools that can do it for you, like IBExpert (I haven't tried
with DBWorkbench, but I suppose it can do it too). I recommend backing
up the database before you do it. After you do it, do a backup and
restore. If restore doesn't fail, then you did it.

You could also dump database schema to sql file, change to column,
create empty database, and pump the data.

Milan Babuskov

Yahoo! Groups Links