Re: professional question
From: Uppili <sestri_at_hotmail.com>
Date: Tue, 04 May 1999 14:07:09 -0500
Message-ID: <372F455D.53DBFBC1_at_hotmail.com>
Date: Tue, 04 May 1999 14:07:09 -0500
Message-ID: <372F455D.53DBFBC1_at_hotmail.com>
Disable the constraints for the schema , recreate the table without the
column ,
populate the rows and enable the constraints..This shud work.
If you have 8.1 than it is very easy to drop a column..
bye..
a wrote:
> Hello:
>
> I want to drop a column from a table. As it is not possible, I create a
> new one, without this column, and copy the data, schema and so on. But
> the columns of other tables which are referencing as foreign keys to
> columns in the old table (not the dropped one, of course), continue
> referencing to this old table and not to this new one, what I want them
> to do. If anybody knows and easiest way to DROP A COLUMN, please let me
> know. Thanks,
Received on Tue May 04 1999 - 21:07:09 CEST