删除数据库所有的表：
declare @sql varchar(8000) while (select count(*) from sysobjects where type=‘U‘)>0 begin SELECT @sql=‘drop table ‘ + name FROM sysobjects WHERE (type = ‘U‘) ORDER BY ‘drop table ‘ + name exec(@sql) end
原文：http://www.cnblogs.com/coce/p/5026581.html