how to drop a column in a table?

From: Erin A. O'Neill <eon_at_crl.crl.com>
Date: 9 Jun 1999 21:36:27 GMT
Message-ID: <7jmmor$2i2b$1_at_nnrp9.crl.com>



I would like to drop just a column in a table. What's the syntax for this?

I've tried

ALTER TABLE my_table
drop column baddata;

and it doesn't like the drop column (nor drop col)?? any hints??

thanks.
erin

-- 
		--- erin -- eon_at_crl.com ---
			   ---
		     www.madkats.com
"Computers are useless. They can only give you answers." 
--Pablo Picasso (1881-1973)
Received on Wed Jun 09 1999 - 23:36:27 CEST

Original text of this message