Any tool for auto generating DDL deployment scripts should have an option that explicitly confirms 'Allow data loss' yes / no. If no, then additional assertions should be coded that raise and error and aborts before dropping a table that contains data at runtime. There could also be a 'Require backup' yes / no option that adds runtime code to query backupset history to confirm that's been done recently.