批量删除表

DECLARE @tableName AS Nvarchar(50)

--查询表名条件（小心！，确保like条件是你要Drop的表.TableName尽量精确） 

  SET @tableName='IC_'   

  --SELECT name FROM sys.tables   WHERE name LIKE '%'+@tableName+'%' --查询出要删除表的名称 

  IF @tableName='' SET @tableName='tableName'

--初始化TableName为tableName,防止@tableName为空 

  DECLARE @tableNames AS Nvarchar(3000)   

DECLARE @sql AS Nvarchar(3000) 

  SET @tableNames=    (SELECT ','+name FROM sys.tables 

  WHERE name LIKE '%'+@tableName+'%'  FOR XML PATH(''))   

SET @tableNames= Stuff(@tableNames,1,1,'')   

SET @sql='DROP TABLE '+@tableNames  EXEC(@sql)