SQL - Tables

Hi All,
I want to write a sql script that will remove a column from a table.
The table is full of data , so i dont want to drop the table and recreate it.
I've seen some syntax such as
alter table jobs drop jobname
but it doesnt seem to work either.
I think this is only for dropping constraints.

If any one has any ideas , send them on.
Thanks
dave

if you are using access then syntex is ok.
if you are using personal oracle then this syntex will not work due to privalage is not there. This syntex will work on oracle 8i.

pankaj

which database are you running?