删除sql数据库中所有用户表

use my_database
go

-- 删除外键约束
DECLARE c1 cursor for
select ' alter table [ ' + object_name (parent_obj) + ' ] drop constraint [ ' + name + ' ]; '
from sysobjects
where xtype = ' F '
open c1
declare @c1 varchar ( 8000 )
fetch next from c1 into @c1
while ( @@fetch_status = 0 )
begin
exec ( @c1 )
fetch next from c1 into @c1
end
close c1
deallocate c1
-- 删除表
DECLARE c2 cursor for
select ' drop table [ ' + name + ' ]; '
from sysobjects
where xtype = ' u '
open c2
declare @c2 varchar ( 8000 )
fetch next from c2 into @c2
while ( @@fetch_status = 0 )
begin
exec ( @c2 )
fetch next from c2 into @c2
end
close c2
deallocate c2

转载于:https://www.cnblogs.com/illusion/archive/2011/04/13/2014767.html