Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do you rename a column in a table?
> alter table xxx drop column oldcol;
Read the docs as to when you would want to use SET UNUSED vs DROP COLUMN; Received on Wed Jun 13 2001 - 17:18:04 CDT