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