删除数据库所有用户表（SqlServer）

sqlserver 查询分析器里面执行即可

DECLARE curItems CURSOR
FOR select [name] from sysobjects where xtype='U'
FOR READ ONLY
OPEN curItems
DECLARE @n  NVARCHAR(100),@m NVARCHAR(100)
FETCH FROM curItems INTO @n
WHILE @@FETCH_STATUS=0
BEGIN
 set @m=@n
    exec('Drop Table ' + @m)
FETCH NEXT FROM curItems INTO
@n
END
CLOSE  curItems
DEALLOCATE  curItems

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23947808/viewspace-663480/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23947808/viewspace-663480/