it is pondering into my mind, that how to rename a column, and also delete a column. if u can, try to help me to solve this problem.
i used the syntax
ALTER TABLE tablename DROP COLUMN columnname
but the error is comming stating that missing keyword under the word column,
ok, plz solve it .