Re: newbie question: how to delete a column from a table definition

> Maybe there is no way to delete a column definition in a table directly with
> an SQL statement.

 But you can create another table and copy the columns the original table has as you select using "CREATE TABLE ... AS SELECT ... FROM ..." SQL statement.

 You can modify the column type with some limits.  If all the rows have only NULL value, then you can modify column type and size of the column.
But if not, it is impossible to change the data size in an increasing way. In this case you can only modify the column type or size into larger one. Received on Fri Apr 10 1998 - 05:08:18 CDT