查出数据库所有表名

declare @trun_name varchar(8000)
set @trun_name=''
select @trun_name=@trun_name + 'truncate table ' + [name] + ' ' from sysobjects where xtype='U'
select @trun_name

转载于:https://www.cnblogs.com/linyijia/p/3489515.html