DECLARE @TableName varchar(100) --定义存储表名称 DECLARE staff_cursor CURSOR FOR --定义游标进行操作 SELECT [name] FROM sys.sysobjects WHERE type='U' -- 打开游标 OPEN staff_cursor -- 提取记录数据 FETCH Next FROM staff_cursor Into @TableName WHILE @@fetch_status = 0 BEGIN EXEC('DROP TABLE ' + @TableName ) --删除表 PRINT @TableName FETCH Next FROM staff_cursor Into @TableName END CLOSE staff_cursor -- 关闭游标 DEALLOCATE staff_cursor -- 释放游标资源
