数据库删除表中多列语法总结

数据库删除表中多列语法总结

Oracle:

alter table table_name drop (column1,column2);

MS SQL:

alter table table_name drop column column_name1,column_name2;

MySQL:

alter table table_name drop column_name1,drop column_name2;

PostgreSQL:

alter table table_name drop column column_name1,drop column_name2;