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 -> alter table

alter table

From: <chris_at_ultramedia.co.uk>
Date: Tue, 16 Jun 1998 13:38:26 GMT
Message-ID: <6m5sgi$40a$1@nnrp1.dejanews.com>


Hi,

How do I delete a column from a database?

can I just do something along the lines of:-

ALTER TABLE myTable
drop myColumn;

..also can I use a select statement to get data from one database table into another database's table?

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 Received on Tue Jun 16 1998 - 08:38:26 CDT

Original text of this message

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