在不同数据库中如何删除已存在的表的脚本写法

mysql

 

 

 

drop table if exists myTable

 

 

 

 

 

mssqlserver

方式一

 

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'myTable') AND type in (N'U')) 
DROP TABLE myTable

 

 

 

 

 

方式二

if exists(select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'myTable') 
drop table myTable;