use
你要清空的库
go
declare
@tbname
varchar
(
250
)
declare
#tb
cursor
for
select
name
from
sysobjects
where
objectproperty
(id,
'
IsUserTable
'
)
=
1
open
#tb
fetch
next
from
#tb
into
@tbname
while
@@fetch_status
=
0
begin
exec
(
'
delete from [
'
+
@tbname
+
'
]
'
)
fetch
next
from
#tb
into
@tbname
end
close
#tb
deallocate
#tb