declare @name varchar(200) declare @strSql varchar(500) declare C cursor for Select name From sysobjects Where xtype='U' open c fetch next from c into @name while @@FETCH_STATUS=0 begin set @strSql='Truncate Table '+@name exec(@strSql) fetch next from c into @name end close c DEALLOCATE c