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

Home -> Community -> Usenet -> c.d.o.misc -> Re: alter table

Re: alter table

From: <mandrew_at_my-dejanews.com>
Date: Tue, 16 Jun 1998 15:05:44 GMT
Message-ID: <6m61k8$bra$1@nnrp1.dejanews.com>


In article <6m5sgi$40a$1_at_nnrp1.dejanews.com>,   chris_at_ultramedia.co.uk wrote:
>
> Hi,
>
> How do I delete a column from a database?
>
> can I just do something along the lines of:-
>
> ALTER TABLE myTable
> drop myColumn;
>No, there is no command that just lets you drop a column. You can rename the table to new_table_name, create table as the old_table_name minus the column you want dropped, insert into old_table_name select columns_wanted from new_table_name. Rememeber to enable all constraints, create indexes etc.
> ..also can I use a select statement to get data from one database table
> into another database's table?
> Use a database link, then insert into current_table select * from other_table_at_dblink
> TIA
>
> chris_at_ultramedia.co.uk
> ----------------------
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Jun 16 1998 - 10:05:44 CDT

Original text of this message

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