SQL脚本:批量删除所有的用户表
----------------------------------------------------------------------------- --批量删除所有的用户表 ----------------------------------------------------------------------------- DECLARE @DROP_STRING VARCHAR(8000) --删除外键约束 DECLARE DROP_FK CURSOR FOR SELECT 'ALTER TABLE '+ OBJECT_NAME(PARENT_OBJ) + ' DROP CONSTRAINT '+NAME FROM SYSOBJECTS WHERE XTYPE = 'F' OPEN DROP_FK FETCH NEXT FROM DROP_FK INTO @DROP_STRING WHILE(@@FETCH_STATUS=0) BEGIN EXEC(@DROP_STRING) FETCH NEXT FROM DROP_FK INTO @DROP_STRING END CLOSE DROP_FK DEALLOCATE DROP_FK --删除表 DECLARE DROP_TABLE CURSOR FOR SELECT 'DROP TABLE '+NAME FROM SYSOBJECTS WHERE XTYPE = 'U' OPEN DROP_TABLE FETCH NEXT FROM DROP_TABLE INTO @DROP_STRING WHILE(@@FETCH_STATUS=0) BEGIN EXEC(@DROP_STRING) FETCH NEXT FROM DROP_TABLE INTO @DROP_STRING END CLOSE DROP_TABLE DEALLOCATE DROP_TABLE GO
作者:Zgray
本文版权归作者和博客园共有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接,否则保留追究法律责任的权利。