Subject Re: Rename FOREIGN KEY column
Author Milan Babuskov
--- vojtech.vild wrote:
> is in the Firebird an easy way how to rename FOREIGN KEY column?

1. Drop the foreign key
2. Rename the column
3. Recreate the foreign key

> (or the PRIMARY KEY column)

This might be tricky, since PK is often referenced by foreign keys of
other tables. So, you need to:

1. drop all the dependencies
2. rename the column
3. recreate the dependencies

You can do this using some tool like FlameRobin to generate all the
needed statements. Open table's properties page and click on Generate
Rebuild Script.

--
Milan Babuskov
http://fbexport.sourceforge.net