alter table

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