清空数据库所有表数据

清空数据库所有表数据

  declare c cursor for 
  select name from sysobjects  where xtype='u' order by name;

  open c;
  declare @t varchar(200);
  declare @sql varchar(max);

  fetch next from c into @t;
  while(@@FETCH_STATUS=0)
  begin
    set @sql='truncate table '+@t;
    exec(@sql);

    fetch next from c into @t;
  end;

  close c;
  deallocate c;