| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Help! How to delete a column?
> I have added a column which I don't really want in a table. How can I
> delete it?
You need to drop and recreate the table without the column. If you need to save data, you might consider something like:
RENAME badtablename TO temptablename;
CREATE TABLE badtablename AS SELECT col1, col2 ... FROM temptablename;
DROP TABLE temptablename;
Received on Sat Aug 02 1997 - 00:00:00 CDT
 |
 |