删除一列时:
alter table TableName drop [column] 列名;
删除多列时:
alter table TableName
drop column
列名1,drop column
列名2;
例如:
ALTER table bo_eu_product_permission
drop COLUMNORGID
,
drop COLUMNBINDID
,
drop COLUMNCREATEDATE
,
drop COLUMNCREATEUSER
,
drop COLUMNUPDATEDATE
,
drop COLUMNUPDATEUSER
,
drop COLUMNPROCESSDEFID
,
drop COLUMNISEND
;