Re: How do I rename a column in a table
From: Richard Hull <rich_at_work_at_bigfoot.com>
Date: Fri, 13 Nov 1998 16:49:45 -0500
Message-ID: <72i9s0$sd6$1_at_lore.csc.com>
Date: Fri, 13 Nov 1998 16:49:45 -0500
Message-ID: <72i9s0$sd6$1_at_lore.csc.com>
You should realize that this is not a very good answer. Creating the new table does not duplicate the indexes, foreign keys, views, grants... When you drop the old table, those things either go away, or in the case of incoming references, block the table drop unless you specify the cascade constraints clause.
I just wanted you to know that you may have quite a bit of cleanup/patchup to do after performing Oracle's "solution".
-Rich. Received on Fri Nov 13 1998 - 22:49:45 CET