declare @trun_name varchar(50) declare name_cursor cursor for select 'truncate table ' + name from sysobjects where xtype='U' and status > 0 open name_cursor fetch next from name_cursor into @trun_name while @@FETCH_STATUS = 0 begin exec (@trun_name) print 'truncated table ' + @trun_name fetch next from name_cursor into @trun_name end close name_cursor deallocate name_cursor