How do I start Clean
 

ITs been awhile since I used the DB's and I want to start with fresh everything minus items, I want to keep the items from PEQ but i want to start with no npc's no quests, no loots, nothing. I forget what tables handle that.

I know how to start with no quests, but does anyone know if I can just drop the contents of like 4-7 tables to clear out the rest of it so I can start scratch, and if you could tell me how to clear out items to that would be great as i MIGHT decide to go that route as well.

Let's see,
Items= items
npc's= npc_types, spawngroup, spawnentry, spawn2
loot= lootdrop, lootdrop_entries, loottable, loottable_entries
grids= grid, grid_entries

also if you want to clear these:
merchants= merchantlist
factions= faction_list, npc_faction, npc_faction_entries
starting items= starting_items
ground spawns= ground_spawns

Thank you!

Keep in mind you'll break pet spells, as well as reagent-related spells by doing this.

It's a good effort though if you do get it to work. Good luck!