Re: ALTER DROP COLUMN

I know it's a pain, but it isn't all that bad. Just rename your
table like so:

ALTER TABLE <old_name> RENAME TO <another_name>

Then re-create the old table without the deleted column(s):

SELECT col1, col2, col4 INTO TABLE <old_name> FROM
<another_name>

Then delete the old table:

DROP TABLE <another_name>

--- "ross::barna" <rbarna(at)neochi(dot)com> wrote:
> neochi=> ALTER TABLE news DROP COLUMN date;
> ERROR: ALTER TABLE/DROP COLUMN not yet implemented
>
>
> What's that about??? How do I drop a field of a table?!
>
> Thanks,
> -Ross
>

__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/