Re: professional question

From: Uppili <>
Date: Tue, 04 May 1999 14:07:09 -0500
Message-ID: <>

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

Original text of this message