Re: how do i drop a column?

This is a way to accomplish what you want:

RENAME the_table TO the_table_temp;
CREATE TABLE the_table AS
SELECT field1, field2...fieldn -- exclude field you don't want FROM the_table_temp;
DROP TABLE the_table_temp;

If anyone knows a way to actually drop a column from a table, please let me know.

Misha

John Matzen wrote:

> i know that has got to be a dumb question, but i have a column in a
> table and i need to get rid of it...
Received on Fri Mar 19 1999 - 17:42:51 CST