Subject | Re: Rename FOREIGN KEY column |
---|---|
Author | Milan Babuskov |
Post date | 2007-08-16T08:09:39Z |
--- vojtech.vild wrote:
2. Rename the column
3. Recreate the foreign key
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
> 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