SQLSERVER 判斷table是否存在，如有drop table

有兩種：

 

IF EXISTS (SELECT 1
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE='BASE TABLE'
AND TABLE_NAME='tablename')
DROP TABLE tablename

或

IF OBJECT_ID('tablename','U') is not null
DROP TABLE dbo.tablename