Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: newbie question: how to delete a column from a table definition

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

From: tae sik <tshan_at_kofex.com>
Date: Fri, 10 Apr 1998 19:08:18 +0900
Message-ID: <352DEF92.A440CA6F@kofex.com>


> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US