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?
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