oracle,sqlserver,MySQL数据库语句对照表

核心提示：MYSQL: alter table `leave` RENAME to `leave01`;-- 删除表语句ORACLE: drop table table_name;SQLSERVER: drop table table_name;MYSQL: drop table table_name-- 删除所有表的语句SQL

MYSQL:
alter table `leave` RENAME to `leave01`;
-- 删除表语句
ORACLE:
drop table table_name;
SQLSERVER:
drop table table_name;
MYSQL:
drop table table_name
-- 删除所有表的语句
SQLSERVER:
exec sp_msforeachtable 'drop table ?';
-- 修改列名
SQLSERVER:
EXEC sp_rename '表名.列名','新列名','column';
-- 删除记录
ORACLE:
delete (from) tablename where _column_name=?;