delete

delete from `achievement_criteria_data`;
delete from `achievement_dbc`;
delete from `achievement_reward`;
delete from `creature_template`;
delete from `creature_model_info`;
delete from `creature_questender`;
delete from `creature_questrelation`;
delete from `creature_queststarter`;
delete from `creature_text`;
delete from `creature_template_addon`;
delete from `creature`;
delete from `gameobject`;
delete from `gameobject_template`;
delete from `creature_onkill_reputation`;
delete from `creature_loot_template`;
delete from `game_event_npc_vendor`;
delete from `npc_text`;
delete from `npc_trainer`;
delete from `npc_vendor`;
delete from `page_text`;
delete from `creature_equip_template`;
delete from `creature_addon`;
delete from `quest_template`;
delete from `pool_gameobject`;
delete from `game_event_gameobject`;