使用SQL查询分析器删除所有用户表

use DATABASENAME --DATABASENAME 是待清理的数据库 GO DECLARE @au_lname varchar(40),@SQLString NVARCHAR(500) declare tb cursor for select name from sysobjects where xtype='U' OPEN tb -- Perform the first fetch. FETCH NEXT FROM tb INTO @au_lname -- Check @@FETCH_STATUS to see if there are any more rows to fetch. WHILE @@FETCH_STATUS = 0 BEGIN -- This is executed as long as the previous fetch succeeds. FETCH NEXT FROM tb INTO @au_lname SET @SQLString='Drop table '+ @au_lname EXEC sp_executesql @SQLString --DROP TABLE @au_lname END CLOSE tb DEALLOCATE tb GO