Joined: 10 Mar 2005 Posts: 432 Location: Milan, Italy
Do you want delete all the record of a table or you want delete the column?
If you want delete all the rows of a column you must update all the record for that column erasing so its value.
If you want delete the column you must ALTER the table and DROP the column you desire as you can see below:
ALTER TABLE mytable
DROP COLUMN mycolumn
But it's a danger solution if you don't know its refereces...
Look before you drop if it is a PRIMARY or FOREING KEY!