declare curTable cursor for select name from sysobjects where xtype='U' declare @t_table varchar(100) declare @t_sql varchar(200) open curTable fetch curTable into @t_table while @@fetch_status = 0 begin set @t_sql='delete from ' + @t_table exec (@t_sql) fetch curTable into @t_table end deallocate curTable