[Suche] DB Cleaner

[Rykou!]

Ich brauch 'nen Datenbank-Cleaner für meine Mssql-DB.. jemand 'nen Link oder sowas ?

[Sedrika]

Führ das hier einfach aus:

USE [ACCOUNT_DBF]
GO
DELETE FROM ACCOUNT_TBL
DELETE FROM ACCOUNT_TBL_DETAIL
DELETE FROM AccountPlay
DELETE FROM CashHistory
DELETE FROM Event_PCZone_20091027
DELETE FROM Event_PCZone_20091027_01
DELETE FROM PCZone
DELETE FROM PCZoneIP
DELETE FROM tblEvent_Board_Provide
DELETE FROM tblEventRecommend

USE [CHARACTER_01_DBF]
GO
DELETE FROM armor
DELETE FROM BANK_EXT_TBL
DELETE FROM BANK_TBL
DELETE FROM BILING_ITEM_TBL
DELETE FROM CARD_CUBE_TBL
DELETE FROM CARD_CUBE_TBL
DELETE FROM CHARACTER_TBL
DELETE FROM CHARACTER_TBL_DEL
DELETE FROM CHARACTER_TBL_penya_check
DELETE FROM CHARACTER_TBL_validity_check
DELETE FROM COMPANY_TBL
DELETE FROM EVIDANCE
DELETE FROM GUILD_BANK_EXT_TBL
DELETE FROM GUILD_BANK_TBL
DELETE FROM GUILD_COMBAT_1TO1_BATTLE_PERSON_TBL
DELETE FROM GUILD_COMBAT_1TO1_BATTLE_TBL
DELETE FROM GUILD_COMBAT_1TO1_TENDER_TBL
DELETE FROM GUILD_MEMBER_TBL
DELETE FROM GUILD_QUEST_TBL
DELETE FROM GUILD_TBL
DELETE FROM GUILD_VOTE_TBL
DELETE FROM GUILD_WAR_TBL
DELETE FROM INVENTORY_EXT_TBL
DELETE FROM INVENTORY_TBL
DELETE FROM ITEM_REMOVE_TBL
DELETE FROM ITEM_SEND_TBL
DELETE FROM JOB_SKILL_TBL
DELETE FROM [level]
DELETE FROM MAIL_TBL
DELETE FROM MESSENGER_TBL
DELETE FROM PARTY_TBL
DELETE FROM QUEST_TBL
DELETE FROM RAINBOWRACE_TBL
DELETE FROM SECRET_ROOM_MEMBER_TBL
DELETE FROM SECRET_ROOM_TBL
DELETE FROM SKILL_TBL
DELETE FROM SKILLINFLUENCE_TBL
DELETE FROM TAG_TBL
DELETE FROM TASKBAR_ITEM_TBL
DELETE FROM TASKBAR_TBL
DELETE FROM TAX_DETAIL_TBL
DELETE FROM TAX_INFO_TBL
DELETE FROM TB_VALENTINE_EVENT
DELETE FROM tblAccountList
DELETE FROM tblCampus
DELETE FROM tblCampusMember
DELETE FROM tblChangeBankPW
DELETE FROM tblCombatInfo
DELETE FROM tblCombatJoinGuild
DELETE FROM tblCombatJoinPlayer
DELETE FROM tblCouple
DELETE FROM tblCouplePlayer
DELETE FROM tblCouple_deleted
DELETE FROM tblElection
DELETE FROM tblEvent_Board_Provide
DELETE FROM tblFunnyCoin
DELETE FROM tblGuildHouse
DELETE FROM tblGuildHouse_Furniture
DELETE FROM tblHousing
DELETE FROM tblHousing_Visit
DELETE FROM tblLogout_Penya
DELETE FROM tblLogout_Penya_Diff_Log
DELETE FROM tblLord
DELETE FROM tblLordCandidates
DELETE FROM tblLordElection
DELETE FROM tblLordElector
DELETE FROM tblLordEvent
DELETE FROM tblLordSkill
DELETE FROM tblMaster_all
DELETE FROM tblMessenger
DELETE FROM tblPocket
DELETE FROM tblPocketExt
DELETE FROM tblPropose
DELETE FROM tblQuiz
DELETE FROM tblQuizAnswer
DELETE FROM tblRemoveItemFromGuildBank
DELETE FROM tblRestPoint
DELETE FROM tblSkillPoint
DELETE FROM WANTED_TBL

USE [LOGGING_01_DBF]
GO
DELETE FROM CHARACTER_TBL
DELETE FROM LOG_BILLING_ITEM_TBL
DELETE FROM LOG_CHARACTER_TBL
DELETE FROM LOG_DEATH_TBL
DELETE FROM LOG_GAMEMASTER_TBL
DELETE FROM LOG_GUILD_BANK_TBL
DELETE FROM LOG_GUILD_DISPERSION_TBL
DELETE FROM LOG_GUILD_SERVICE_TBL
DELETE FROM LOG_GUILD_TBL
DELETE FROM LOG_GUILD_WAR_TBL
DELETE FROM LOG_HONOR_TBL
DELETE FROM LOG_INS_DUNGEON_TBL
DELETE FROM LOG_ITEM_EVENT_TBL
DELETE FROM LOG_ITEM_REMOVE_TBL
DELETE FROM LOG_ITEM_SEND_TBL
DELETE FROM LOG_ITEM_TBL
DELETE FROM LOG_LEVELUP_TBL
DELETE FROM LOG_PK_PVP_TBL
DELETE FROM LOG_LOGIN_TBL
DELETE FROM LOG_QUEST_TBL
DELETE FROM LOG_RESPAWN_TBL
DELETE FROM LOG_SKILL_FREQUENCY_TBL
DELETE FROM LOG_SVRDOWN_TBL
DELETE FROM LOG_UNIQUE_TBL
DELETE FROM LOG_USER_CNT_TBL
DELETE FROM tblCampus_PointLog
DELETE FROM tblCampusLog
DELETE FROM tblChangeNameHistoryLog
DELETE FROM tblChangeNameLog
DELETE FROM tblGuildHouse_FurnitureLog
DELETE FROM tblGuildHouseLog
DELETE FROM tblLogExpBox
DELETE FROM tblPetLog
DELETE FROM tblQuestLog
DELETE FROM tblQuizAnswerLog
DELETE FROM tblQuizLog
DELETE FROM tblQuizUserLog
DELETE FROM tblSkillPointLog
DELETE FROM tblSystemErrorLog
DELETE FROM tblTradeDetailLog
DELETE FROM tblTradeItemLog
DELETE FROM tblTradeLog

USE [RANKING_DBF]
GO
DELETE FROM RANKING_TBL

Das macht die ganze DB leer.

[Rykou!]

Vielen Dank <3

[Slepnix]

Originally Posted by [Liq'uid_*

Vielen Dank <3

#closerequest