--查看所有用户表
select * from sys.tables where is_ms_shipped=0 order by name asc
--删除
use master;
go
sp_msforeachtable @command1="drop table ?"
go
--查看所有用户表
select * from sys.tables where is_ms_shipped=0 order by name asc
--删除
use master;
go
sp_msforeachtable @command1="drop table ?"
go