[QUERY] Query Para Limpar a DB toda

27 de Outubro de 2009
1
4
0
30
#1
Bom estou aqui para postar a todos uma query que fiz para limpar e zerar a DB.

Tentei usar varias query que peguei aqui no forum mais sempre sem sucesso.

 Segue:

Código:
USE [Account]
GO
TRUNCATE TABLE [dbo].[cabal_additional_dungeon_instance_table]
TRUNCATE TABLE [dbo].[cabal_AlzEarnLock_table]
TRUNCATE TABLE [dbo].[cabal_auth_table]
TRUNCATE TABLE [dbo].[cabal_autoblock_log]
TRUNCATE TABLE [dbo].[cabal_blockip_list]
TRUNCATE TABLE [dbo].[cabal_blockuser_table]
TRUNCATE TABLE [dbo].[cabal_bot_report_table]
TRUNCATE TABLE [dbo].[cabal_character_count_table]
TRUNCATE TABLE [dbo].[cabal_charge_auth]
TRUNCATE TABLE [dbo].[cabal_freeip_list]
TRUNCATE TABLE [dbo].[cabal_GM_ip_table]
TRUNCATE TABLE [dbo].[cabal_hackuser_list]
TRUNCATE TABLE [dbo].[cabal_otp_table]
TRUNCATE TABLE [dbo].[cabal_permission_shop]
TRUNCATE TABLE [dbo].[cabal_sub_password_table]
TRUNCATE TABLE [dbo].[cabalapp_android_push_category]
TRUNCATE TABLE [dbo].[cabalapp_android_push_message]
TRUNCATE TABLE [dbo].[cabalapp_android_registration_id]
TRUNCATE TABLE [dbo].[cabalapp_iphone_device_token]
TRUNCATE TABLE [dbo].[cabalapp_iphone_lastlogin]
TRUNCATE TABLE [dbo].[cabalapp_iphone_push_category]
TRUNCATE TABLE [dbo].[cabalapp_iphone_push_message]
TRUNCATE TABLE [dbo].[facebook_authcode]
TRUNCATE TABLE [dbo].[facebook_event]
TRUNCATE TABLE [dbo].[facebook_event_category]
TRUNCATE TABLE [dbo].[facebook_event_log]
TRUNCATE TABLE [dbo].[facebook_event_log_image]
TRUNCATE TABLE [dbo].[facebook_userevent]
TRUNCATE TABLE [dbo].[facebook_usermapping]
TRUNCATE TABLE [dbo].[ipchecking]
TRUNCATE TABLE [dbo].[Web_Log]
TRUNCATE TABLE [dbo].[Web_Vote]
TRUNCATE TABLE [dbo].[Web_Wall]

USE [CabalCash]
GO
TRUNCATE TABLE [dbo].[CashAccount]
TRUNCATE TABLE [dbo].[CashChargeErrorLog]
TRUNCATE TABLE [dbo].[CashLog]
TRUNCATE TABLE [dbo].[CashLogType]
TRUNCATE TABLE [dbo].[CashPremiumLog]
TRUNCATE TABLE [dbo].[epoint_buy]
TRUNCATE TABLE [dbo].[epoint_charge]
TRUNCATE TABLE [dbo].[epoint_charge_transfer]
TRUNCATE TABLE [dbo].[GiftCashLog]
TRUNCATE TABLE [dbo].[MyCashItem]
TRUNCATE TABLE [dbo].[npc_deleteCashLog]
TRUNCATE TABLE [dbo].[PAYPAL_LOG]
TRUNCATE TABLE [dbo].[VoucherDetails]
TRUNCATE TABLE [dbo].[VoucherItemMaster]
TRUNCATE TABLE [dbo].[VoucherMaster]

USE [CabalGuild]
GO 
TRUNCATE TABLE [dbo].[Guildboard]
TRUNCATE TABLE [dbo].[GuildBoardComment]
TRUNCATE TABLE [dbo].[GuildDetail]
TRUNCATE TABLE [dbo].[GuildGuestBoard]
TRUNCATE TABLE [dbo].[GuildInfo]
TRUNCATE TABLE [dbo].[GuildMaster_Change_Log]
TRUNCATE TABLE [dbo].[tempguild]

USE [NetcafeBilling]
GO
TRUNCATE TABLE [dbo].[Point]

USE [Server01]
GO
TRUNCATE TABLE [dbo].[cabal_achievement_history]
TRUNCATE TABLE [dbo].[cabal_achievement_open]
TRUNCATE TABLE [dbo].[cabal_achievement_title]
TRUNCATE TABLE [dbo].[cabal_achievement_title_shared]
TRUNCATE TABLE [dbo].[cabal_agentshop_bookmark]
TRUNCATE TABLE [dbo].[cabal_agentshop_done_table]
TRUNCATE TABLE [dbo].[cabal_agentshop_pet_table]
TRUNCATE TABLE [dbo].[cabal_agentshop_price_average]
TRUNCATE TABLE [dbo].[cabal_agentshop_price_daily]
TRUNCATE TABLE [dbo].[cabal_agentshop_sale_table]
TRUNCATE TABLE [dbo].[cabal_alzSupply_table]
TRUNCATE TABLE [dbo].[cabal_Assistant_table]
TRUNCATE TABLE [dbo].[cabal_badwoard]
TRUNCATE TABLE [dbo].[cabal_bbead_table]
TRUNCATE TABLE [dbo].[cabal_character_table]
TRUNCATE TABLE [dbo].[cabal_craft_table]
TRUNCATE TABLE [dbo].[cabal_DungeonPoint_table]
TRUNCATE TABLE [dbo].[cabal_DungeonRanking_Data_table]
TRUNCATE TABLE [dbo].[cabal_DungeonRankingParty_table]
TRUNCATE TABLE [dbo].[cabal_DungeonRankingSingle_table]
TRUNCATE TABLE [dbo].[cabal_ems_userstate_table]
TRUNCATE TABLE [dbo].[cabal_equipment_lock_table]
TRUNCATE TABLE [dbo].[cabal_equipment_table]
TRUNCATE TABLE [dbo].[cabal_event_partydg]
TRUNCATE TABLE [dbo].[cabal_event_singledg]
TRUNCATE TABLE [dbo].[cabal_event_special_character_data]
TRUNCATE TABLE [dbo].[cabal_event_special_character_data_for_client]
TRUNCATE TABLE [dbo].[cabal_Forcecalibur_Owner]
TRUNCATE TABLE [dbo].[cabal_guildEnterLog_table]
TRUNCATE TABLE [dbo].[cabal_GuildLord_WinnerRecord]
TRUNCATE TABLE [dbo].[cabal_guildMaxCcu_table]
TRUNCATE TABLE [dbo].[cabal_help_table]
TRUNCATE TABLE [dbo].[cabal_instantWar_nationRewardWarResults]
TRUNCATE TABLE [dbo].[Cabal_InstantWar_Penalty_table]
TRUNCATE TABLE [dbo].[cabal_instantWar_results]
TRUNCATE TABLE [dbo].[cabal_instantWar_statistics]
TRUNCATE TABLE [dbo].[cabal_Inventory_table]
TRUNCATE TABLE [dbo].[cabal_item_extend_table]
TRUNCATE TABLE [dbo].[cabal_last_login_character]
TRUNCATE TABLE [dbo].[cabal_itemserial_table]
TRUNCATE TABLE [dbo].[cabal_LordOfWar_point_table]
TRUNCATE TABLE [dbo].[cabal_LordOfWar_Rank_table]
TRUNCATE TABLE [dbo].[cabal_LordOfWar_table]
TRUNCATE TABLE [dbo].[cabal_mail_notice_forward_table]
DELETE FROM [dbo].[cabal_mail_notice_table]
TRUNCATE TABLE [dbo].[cabal_mail_received_table]
TRUNCATE TABLE [dbo].[cabal_mail_report_table]
TRUNCATE TABLE [dbo].[cabal_mail_sent_pet_table]
DELETE FROM [dbo].[cabal_mail_sent_table]
DELETE FROM [dbo].[cabal_pet_table]
TRUNCATE TABLE [dbo].[cabal_qddata_table]
TRUNCATE TABLE [dbo].[cabal_questdata_table]
TRUNCATE TABLE [dbo].[cabal_quickslot_table]
TRUNCATE TABLE [dbo].[cabal_record_combo]
TRUNCATE TABLE [dbo].[cabal_saved_buff_table]
TRUNCATE TABLE [dbo].[cabal_skilllist_table]
TRUNCATE TABLE [dbo].[cabal_sold_item_table]
TRUNCATE TABLE [dbo].[cabal_soul_ability_table]
TRUNCATE TABLE [dbo].[cabal_title_guild]
TRUNCATE TABLE [dbo].[Cabal_Title_PlayHistory]
TRUNCATE TABLE [dbo].[Cabal_Title_Show_Table]
TRUNCATE TABLE [dbo].[Cabal_Title_Table]
TRUNCATE TABLE [dbo].[cabal_title_viaserver_table]
TRUNCATE TABLE [dbo].[cabal_tool_agentshop_auto_item_table]
TRUNCATE TABLE [dbo].[cabal_tool_agentshop_auto_table]
TRUNCATE TABLE [dbo].[cabal_tool_agentshop_log_table]
TRUNCATE TABLE [dbo].[cabal_tool_agentshop_schedule_log_table]
TRUNCATE TABLE [dbo].[cabal_tool_agentshop_search_item_table]
TRUNCATE TABLE [dbo].[cabal_warehouse_ext_table]
TRUNCATE TABLE [dbo].[cabal_warehouse_ext2_table]
TRUNCATE TABLE [dbo].[cabal_warehouse_table]
TRUNCATE TABLE [dbo].[cabal_WarExp_Table]
TRUNCATE TABLE [dbo].[cabalapp_log_table]
TRUNCATE TABLE [dbo].[chat_buddy_pr_message]
TRUNCATE TABLE [dbo].[chat_buddy_table]
TRUNCATE TABLE [dbo].[chat_buddygroup_table]
TRUNCATE TABLE [dbo].[ChatBlacklist]
TRUNCATE TABLE [dbo].[chg_mrank]
TRUNCATE TABLE [dbo].[chg_srank]
TRUNCATE TABLE [dbo].[deleted_cabal_achievement_title]
TRUNCATE TABLE [dbo].[deleted_cabal_character_table]
TRUNCATE TABLE [dbo].[deleted_cabal_inventory_table]
TRUNCATE TABLE [dbo].[deleted_cabal_item_extend_table]
TRUNCATE TABLE [dbo].[deleted_Cabal_Title_PlayHistory]
TRUNCATE TABLE [dbo].[EVENT_LEVELUP_NEWCHAR_TABLE]
TRUNCATE TABLE [dbo].[Guild]
TRUNCATE TABLE [dbo].[guild_backup]
TRUNCATE TABLE [dbo].[guild_level_limit]
TRUNCATE TABLE [dbo].[guild_warehouse_log]
TRUNCATE TABLE [dbo].[guild_warehouse_table]
TRUNCATE TABLE [dbo].[GuildGroup]
TRUNCATE TABLE [dbo].[GuildMember]
TRUNCATE TABLE [dbo].[levelUpStepTable]
TRUNCATE TABLE [dbo].[LevUpEventWinTable]
TRUNCATE TABLE [dbo].[log_nation]
TRUNCATE TABLE [dbo].[Mail]
 
28 de Setembro de 2014
6
0
1
#4
Bom estou aqui para postar a todos uma query que fiz para limpar e zerar a DB.

Tentei usar varias query que peguei aqui no forum mais sempre sem sucesso.

Segue:

Código:
USE [Account]
GO
TRUNCATE TABLE [dbo].[cabal_additional_dungeon_instance_table]
TRUNCATE TABLE [dbo].[cabal_AlzEarnLock_table]
TRUNCATE TABLE [dbo].[cabal_auth_table]
TRUNCATE TABLE [dbo].[cabal_autoblock_log]
TRUNCATE TABLE [dbo].[cabal_blockip_list]
TRUNCATE TABLE [dbo].[cabal_blockuser_table]
TRUNCATE TABLE [dbo].[cabal_bot_report_table]
TRUNCATE TABLE [dbo].[cabal_character_count_table]
TRUNCATE TABLE [dbo].[cabal_charge_auth]
TRUNCATE TABLE [dbo].[cabal_freeip_list]
TRUNCATE TABLE [dbo].[cabal_GM_ip_table]
TRUNCATE TABLE [dbo].[cabal_hackuser_list]
TRUNCATE TABLE [dbo].[cabal_otp_table]
TRUNCATE TABLE [dbo].[cabal_permission_shop]
TRUNCATE TABLE [dbo].[cabal_sub_password_table]
TRUNCATE TABLE [dbo].[cabalapp_android_push_category]
TRUNCATE TABLE [dbo].[cabalapp_android_push_message]
TRUNCATE TABLE [dbo].[cabalapp_android_registration_id]
TRUNCATE TABLE [dbo].[cabalapp_iphone_device_token]
TRUNCATE TABLE [dbo].[cabalapp_iphone_lastlogin]
TRUNCATE TABLE [dbo].[cabalapp_iphone_push_category]
TRUNCATE TABLE [dbo].[cabalapp_iphone_push_message]
TRUNCATE TABLE [dbo].[facebook_authcode]
TRUNCATE TABLE [dbo].[facebook_event]
TRUNCATE TABLE [dbo].[facebook_event_category]
TRUNCATE TABLE [dbo].[facebook_event_log]
TRUNCATE TABLE [dbo].[facebook_event_log_image]
TRUNCATE TABLE [dbo].[facebook_userevent]
TRUNCATE TABLE [dbo].[facebook_usermapping]
TRUNCATE TABLE [dbo].[ipchecking]
TRUNCATE TABLE [dbo].[Web_Log]
TRUNCATE TABLE [dbo].[Web_Vote]
TRUNCATE TABLE [dbo].[Web_Wall]

USE [CabalCash]
GO
TRUNCATE TABLE [dbo].[CashAccount]
TRUNCATE TABLE [dbo].[CashChargeErrorLog]
TRUNCATE TABLE [dbo].[CashLog]
TRUNCATE TABLE [dbo].[CashLogType]
TRUNCATE TABLE [dbo].[CashPremiumLog]
TRUNCATE TABLE [dbo].[epoint_buy]
TRUNCATE TABLE [dbo].[epoint_charge]
TRUNCATE TABLE [dbo].[epoint_charge_transfer]
TRUNCATE TABLE [dbo].[GiftCashLog]
TRUNCATE TABLE [dbo].[MyCashItem]
TRUNCATE TABLE [dbo].[npc_deleteCashLog]
TRUNCATE TABLE [dbo].[PAYPAL_LOG]
TRUNCATE TABLE [dbo].[VoucherDetails]
TRUNCATE TABLE [dbo].[VoucherItemMaster]
TRUNCATE TABLE [dbo].[VoucherMaster]

USE [CabalGuild]
GO
TRUNCATE TABLE [dbo].[Guildboard]
TRUNCATE TABLE [dbo].[GuildBoardComment]
TRUNCATE TABLE [dbo].[GuildDetail]
TRUNCATE TABLE [dbo].[GuildGuestBoard]
TRUNCATE TABLE [dbo].[GuildInfo]
TRUNCATE TABLE [dbo].[GuildMaster_Change_Log]
TRUNCATE TABLE [dbo].[tempguild]

USE [NetcafeBilling]
GO
TRUNCATE TABLE [dbo].[Point]

USE [Server01]
GO
TRUNCATE TABLE [dbo].[cabal_achievement_history]
TRUNCATE TABLE [dbo].[cabal_achievement_open]
TRUNCATE TABLE [dbo].[cabal_achievement_title]
TRUNCATE TABLE [dbo].[cabal_achievement_title_shared]
TRUNCATE TABLE [dbo].[cabal_agentshop_bookmark]
TRUNCATE TABLE [dbo].[cabal_agentshop_done_table]
TRUNCATE TABLE [dbo].[cabal_agentshop_pet_table]
TRUNCATE TABLE [dbo].[cabal_agentshop_price_average]
TRUNCATE TABLE [dbo].[cabal_agentshop_price_daily]
TRUNCATE TABLE [dbo].[cabal_agentshop_sale_table]
TRUNCATE TABLE [dbo].[cabal_alzSupply_table]
TRUNCATE TABLE [dbo].[cabal_Assistant_table]
TRUNCATE TABLE [dbo].[cabal_badwoard]
TRUNCATE TABLE [dbo].[cabal_bbead_table]
TRUNCATE TABLE [dbo].[cabal_character_table]
TRUNCATE TABLE [dbo].[cabal_craft_table]
TRUNCATE TABLE [dbo].[cabal_DungeonPoint_table]
TRUNCATE TABLE [dbo].[cabal_DungeonRanking_Data_table]
TRUNCATE TABLE [dbo].[cabal_DungeonRankingParty_table]
TRUNCATE TABLE [dbo].[cabal_DungeonRankingSingle_table]
TRUNCATE TABLE [dbo].[cabal_ems_userstate_table]
TRUNCATE TABLE [dbo].[cabal_equipment_lock_table]
TRUNCATE TABLE [dbo].[cabal_equipment_table]
TRUNCATE TABLE [dbo].[cabal_event_partydg]
TRUNCATE TABLE [dbo].[cabal_event_singledg]
TRUNCATE TABLE [dbo].[cabal_event_special_character_data]
TRUNCATE TABLE [dbo].[cabal_event_special_character_data_for_client]
TRUNCATE TABLE [dbo].[cabal_Forcecalibur_Owner]
TRUNCATE TABLE [dbo].[cabal_guildEnterLog_table]
TRUNCATE TABLE [dbo].[cabal_GuildLord_WinnerRecord]
TRUNCATE TABLE [dbo].[cabal_guildMaxCcu_table]
TRUNCATE TABLE [dbo].[cabal_help_table]
TRUNCATE TABLE [dbo].[cabal_instantWar_nationRewardWarResults]
TRUNCATE TABLE [dbo].[Cabal_InstantWar_Penalty_table]
TRUNCATE TABLE [dbo].[cabal_instantWar_results]
TRUNCATE TABLE [dbo].[cabal_instantWar_statistics]
TRUNCATE TABLE [dbo].[cabal_Inventory_table]
TRUNCATE TABLE [dbo].[cabal_item_extend_table]
TRUNCATE TABLE [dbo].[cabal_last_login_character]
TRUNCATE TABLE [dbo].[cabal_itemserial_table]
TRUNCATE TABLE [dbo].[cabal_LordOfWar_point_table]
TRUNCATE TABLE [dbo].[cabal_LordOfWar_Rank_table]
TRUNCATE TABLE [dbo].[cabal_LordOfWar_table]
TRUNCATE TABLE [dbo].[cabal_mail_notice_forward_table]
DELETE FROM [dbo].[cabal_mail_notice_table]
TRUNCATE TABLE [dbo].[cabal_mail_received_table]
TRUNCATE TABLE [dbo].[cabal_mail_report_table]
TRUNCATE TABLE [dbo].[cabal_mail_sent_pet_table]
DELETE FROM [dbo].[cabal_mail_sent_table]
DELETE FROM [dbo].[cabal_pet_table]
TRUNCATE TABLE [dbo].[cabal_qddata_table]
TRUNCATE TABLE [dbo].[cabal_questdata_table]
TRUNCATE TABLE [dbo].[cabal_quickslot_table]
TRUNCATE TABLE [dbo].[cabal_record_combo]
TRUNCATE TABLE [dbo].[cabal_saved_buff_table]
TRUNCATE TABLE [dbo].[cabal_skilllist_table]
TRUNCATE TABLE [dbo].[cabal_sold_item_table]
TRUNCATE TABLE [dbo].[cabal_soul_ability_table]
TRUNCATE TABLE [dbo].[cabal_title_guild]
TRUNCATE TABLE [dbo].[Cabal_Title_PlayHistory]
TRUNCATE TABLE [dbo].[Cabal_Title_Show_Table]
TRUNCATE TABLE [dbo].[Cabal_Title_Table]
TRUNCATE TABLE [dbo].[cabal_title_viaserver_table]
TRUNCATE TABLE [dbo].[cabal_tool_agentshop_auto_item_table]
TRUNCATE TABLE [dbo].[cabal_tool_agentshop_auto_table]
TRUNCATE TABLE [dbo].[cabal_tool_agentshop_log_table]
TRUNCATE TABLE [dbo].[cabal_tool_agentshop_schedule_log_table]
TRUNCATE TABLE [dbo].[cabal_tool_agentshop_search_item_table]
TRUNCATE TABLE [dbo].[cabal_warehouse_ext_table]
TRUNCATE TABLE [dbo].[cabal_warehouse_ext2_table]
TRUNCATE TABLE [dbo].[cabal_warehouse_table]
TRUNCATE TABLE [dbo].[cabal_WarExp_Table]
TRUNCATE TABLE [dbo].[cabalapp_log_table]
TRUNCATE TABLE [dbo].[chat_buddy_pr_message]
TRUNCATE TABLE [dbo].[chat_buddy_table]
TRUNCATE TABLE [dbo].[chat_buddygroup_table]
TRUNCATE TABLE [dbo].[ChatBlacklist]
TRUNCATE TABLE [dbo].[chg_mrank]
TRUNCATE TABLE [dbo].[chg_srank]
TRUNCATE TABLE [dbo].[deleted_cabal_achievement_title]
TRUNCATE TABLE [dbo].[deleted_cabal_character_table]
TRUNCATE TABLE [dbo].[deleted_cabal_inventory_table]
TRUNCATE TABLE [dbo].[deleted_cabal_item_extend_table]
TRUNCATE TABLE [dbo].[deleted_Cabal_Title_PlayHistory]
TRUNCATE TABLE [dbo].[EVENT_LEVELUP_NEWCHAR_TABLE]
TRUNCATE TABLE [dbo].[Guild]
TRUNCATE TABLE [dbo].[guild_backup]
TRUNCATE TABLE [dbo].[guild_level_limit]
TRUNCATE TABLE [dbo].[guild_warehouse_log]
TRUNCATE TABLE [dbo].[guild_warehouse_table]
TRUNCATE TABLE [dbo].[GuildGroup]
TRUNCATE TABLE [dbo].[GuildMember]
TRUNCATE TABLE [dbo].[levelUpStepTable]
TRUNCATE TABLE [dbo].[LevUpEventWinTable]
TRUNCATE TABLE [dbo].[log_nation]
TRUNCATE TABLE [dbo].[Mail]
Vlw irmão por compartilhar !!! Testado e realmente funciona corretamente