Quick Clean DB

Quote:

ALTER PROCEDURE [dbo].[TClearAll] AS TRUNCATE TABLE TUNIFYPET TRUNCATE TABLE TTOURNAMENTSTATUSTABLE TRUNCATE TABLE TTOURNAMENTPLAYERTABLE TRUNCATE TABLE TTNMTEVENTTABLE TRUNCATE TABLE TTNMTEVENTREWARDTABLE TRUNCATE TABLE TTEMPSKILLTABLE TRUNCATE TABLE TTEMPSKILLMAINTAINTABLE TRUNCATE TABLE TTEMPITEMUSEDTABLE TRUNCATE TABLE TTEMPITEMTABLE TRUNCATE TABLE TTEMPINVENTABLE TRUNCATE TABLE TTEMPEXPITEMTABLE TRUNCATE TABLE TTEMPCABINETTABLE TRUNCATE TABLE TTEMPCABINETITEMTABLE TRUNCATE TABLE TSOULMATETABLE TRUNCATE TABLE TSKILLTABLE TRUNCATE TABLE TSKILLREWARDMONEY TRUNCATE TABLE TSKILLMAINTAINTABLE TRUNCATE TABLE TSKILLLOG TRUNCATE TABLE TRPSGAMERECORDTABLE TRUNCATE TABLE TRESERVEDPOST TRUNCATE TABLE TRENAMED TRUNCATE TABLE TRECALLMONTABLE TRUNCATE TABLE TRECALLMAINTAINTABLE TRUNCATE TABLE TQUESTTERMTABLE TRUNCATE TABLE TQUESTTABLE TRUNCATE TABLE TPVPRECORDTABLE TRUNCATE TABLE TPVPRECENTTABLE TRUNCATE TABLE TPVPOINTTABLE TRUNCATE TABLE TPROTECTEDTABLE TRUNCATE TABLE TPOSTTABLE TRUNCATE TABLE TPOSTITEMTABLE TRUNCATE TABLE TPOSTERRORTABLE TRUNCATE TABLE TPETTABLE TRUNCATE TABLE TOPERATORTABLE TRUNCATE TABLE TMOUNTTABLE TRUNCATE TABLE TMOUNTITEMTABLE TRUNCATE TABLE TMONTHRANKTABLE TRUNCATE TABLE TMONTHPVPOINTTABLE TRUNCATE TABLE TMENTORTABLE TRUNCATE TABLE TITEMUSEDTABLE TRUNCATE TABLE TITEMTABLE TRUNCATE TABLE TITEMLOG TRUNCATE TABLE TITEMCHANGE TRUNCATE TABLE TINVENTABLE TRUNCATE TABLE THOTKEYTABLE TRUNCATE TABLE THEROTABLE TRUNCATE TABLE TGUILDWANTEDTABLE TRUNCATE TABLE TGUILDVOLUNTEERTABLE TRUNCATE TABLE TGUILDTACTICSWANTEDTABLE TRUNCATE TABLE TGUILDTACTICSTABLE TRUNCATE TABLE TGUILDTABLE TRUNCATE TABLE TGUILDRELATION TRUNCATE TABLE TGUILDPVPRECORDTABLE TRUNCATE TABLE TGUILDPVPOINTREWARDTABLE TRUNCATE TABLE TGUILDPLAYLOG TRUNCATE TABLE TGUILDMEMBERTABLE TRUNCATE TABLE TGUILDCABINETTABLE TRUNCATE TABLE TGUILDARTICLETABLE TRUNCATE TABLE TGMREWARDTABLE TRUNCATE TABLE TGMREWARDCHART TRUNCATE TABLE TFRIENDTABLE TRUNCATE TABLE TFRIENDGROUPTABLE TRUNCATE TABLE TFAKESHOPCHART TRUNCATE TABLE TFAKECHARCHART TRUNCATE TABLE TEXPITEMTABLE TRUNCATE TABLE TEVENTQUARTERGIVETABLE TRUNCATE TABLE TEVENTQUARTERCHART TRUNCATE TABLE TEVENTITEMTABLE TRUNCATE TABLE TERASECHARLOG TRUNCATE TABLE TDUELSCORETABLE TRUNCATE TABLE TDUELCHARTABLE TRUNCATE TABLE TCMGIFTTABLE TRUNCATE TABLE TCHARTABLE TRUNCATE TABLE TCASTLEAPPLICANTTABLE TRUNCATE TABLE TCABINETTABLE TRUNCATE TABLE TCABINETITEMTABLE TRUNCATE TABLE TAUCTIONTABLE TRUNCATE TABLE TAUCTIONINTEREST TRUNCATE TABLE TAUCTIONBIDDER TRUNCATE TABLE TAIDTABLE TRUNCATE TABLE TACTIVECHARTABLE TRUNCATE TABLE Premi TRUNCATE TABLE OTESTER

Quote:

ALTER PROCEDURE [dbo].[TClearAll] AS TRUNCATE TABLE USERIPLOG TRUNCATE TABLE TVERSION TRUNCATE TABLE TUSERPROTECTED TRUNCATE TABLE TUSERINFOTABLE TRUNCATE TABLE TUSERATTENDTABLE TRUNCATE TABLE TUNIFYPOSTITEMTABLE TRUNCATE TABLE TUNIFYCASHITEM TRUNCATE TABLE ttempuser TRUNCATE TABLE ttemplevel TRUNCATE TABLE TTEMPDURINGITEMTABLE TRUNCATE TABLE TTEMPCASHITEM TRUNCATE TABLE TSMSTABLE TRUNCATE TABLE TRESERVEDNAME TRUNCATE TABLE TPREVERSION TRUNCATE TABLE TPCBANGPLAYTABLE TRUNCATE TABLE TPCBANGMASTERTABLE TRUNCATE TABLE TMANAGERLOG TRUNCATE TABLE TLOGGEDTODAY TRUNCATE TABLE TLOG TRUNCATE TABLE TLASTMONTHPOINTTABLE TRUNCATE TABLE TIPBAN TRUNCATE TABLE TIPAUTHORITY TRUNCATE TABLE Tgiftitem TRUNCATE TABLE TGIFTCATs TRUNCATE TABLE TEVENTHORSE TRUNCATE TABLE test TRUNCATE TABLE TEMPUSERID TRUNCATE TABLE TempEvent TRUNCATE TABLE TDURINGITEMTABLE TRUNCATE TABLE TCURRENTUSER TRUNCATE TABLE TCOMEBACKTABLE TRUNCATE TABLE TCHARITEMTABLE TRUNCATE TABLE TCASHTESTTABLE TRUNCATE TABLE TCASHITEMCABINETTABLE_temp TRUNCATE TABLE TCASHITEMCABINETTABLE TRUNCATE TABLE TCASHITEMBUYTABLE TRUNCATE TABLE TCABINETITEMCHART TRUNCATE TABLE TALLRANKTABLE TRUNCATE TABLE TALLRANKGUILDTABLE TRUNCATE TABLE TALLLOCALTABLE TRUNCATE TABLE TALLCHARTABLE_TRIGGER TRUNCATE TABLE TALLCHARTABLE_OLD TRUNCATE TABLE TALLCHARTABLE TRUNCATE TABLE TACCOUNTCHARTABLE TRUNCATE TABLE TACCOUNT_BACKUP TRUNCATE TABLE TACCOUNT