Re: professional question

After you created the new table ( the one without the column you want to drop )

did you drop the old table and rename the new one to the old one's name?

If not, do so....

If you did, then I'm stumped......

Hope it helps...

( by the way, be sure and verify that the new table has all the data you need before the drop/rename step....)

John Greco

a <izaguirn_at_iis.fhg.de> 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 - 18:49:31 CEST