1。先导库:结构+数据
2。删数据:
declare @i int
declare @s int
declare @n varchar(100)
select identity(int,1,1) as id, name into #t
from sysobjects where type = 'u'
select @s = count(*) from #t
set @i = 1
while @i <= @s
begin
select @n = name from #t where id = @i
set @i = @i + 1
exec ('truncate table '+@n)
end