摘要:
sometimes, we have no rights to drop the whole database in SQL SERVER. But we still want to clear the the database and recreate tables/constraints/views/functions/store procedure etc.The following is the script. use at your risk. 1 /* Drop all non-system stored procs */ 2 DECLARE @name VARCHAR(128.. 阅读全文