Anyone know a better way to drop all tables in a MS SQL Server 2000 Database than dropping and recreating the entire database? Especially one that won't require me to close query analyzer windows connected to that database and will take FK relationships into consideration so it doesn't throw an error instead of deleting the table.

Thanks.

Code:
USE master
GO

DROP DATABASE Purchasing

IF @@ERROR = 0 CREATE DATABASE Purchasing
GO