> A command for remove the column but it not work> it gives parse error> ALTER TABLE tablename DROP COLUMN fieldname;
drop column feature is implemented since 7.3. So, you please check outyour version.
regards,bhuvaneswaran