Very useful (And dangerous) little script to quickly clear out a Db of tables. If you get constraint errors, just keep running it and it will clear dependencies and then the children.

EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"

This post is for information purposes only. Again, be very careful using this script.