Very useful when moving towards Features: DELETE FROM blocks WHERE theme = 'your_theme_name'; From drush sql-cli, of course. This is especially useful when building a subsite, for which I'm now mostly convinced by Sections.