Re: Change/delete column name without drop table?
From: Y.P.J. Maspaitella <y.mas_at_worldonline.nl>
Date: Sun, 7 Feb 1999 23:06:02 +0100
Message-ID: <79l2lm$7d2$1_at_news.worldonline.nl>
Date: Sun, 7 Feb 1999 23:06:02 +0100
Message-ID: <79l2lm$7d2$1_at_news.worldonline.nl>
Albert,
Try duplicating your table with a Select Statement.
Leave or rename your column in this statement.
Remember, give this table another name.
If you rename there will be only NULL values in this column.
Drop the "old" table.
Rename the "new" table with the name of your "old" table.
Regards Yvo. Received on Sun Feb 07 1999 - 23:06:02 CET