快速删除DiscuzNT论坛数据表和存储过程


本来想一个一个删除的,打开数据库一看那么多的表和存储过程,就放弃这种笨办法了,于是决定用SQL语句来搞定。代码如下:

复制代码
代码如下:

-----------------------------删除数据表---------------------
DECLARE @au_lname VARCHAR(40),@SQLString NVARCHAR(500)
DECLARE tb CURSOR FOR
SELECT name FROM sysobjects WHERE xtype='U' and name like 'dnt%'
OPEN tb
-- Perform the FIRST FETCH.
FETCH NEXT FROM tb INTO @au_lname
-- CHECK @@FETCH_STATUS TO see IF there ARE ANY more ROWS TO FETCH.
WHILE @@FETCH_STATUS = 0
BEGIN
-- This IS executed AS long AS the previous FETCH succeeds.
FETCH NEXT FROM tb INTO @au_lname
SET @SQLString='DROP TABLE '+ @au_lname
EXEC sp_executesql @SQLString
--DROP TABLE @au_lname
END
CLOSE tb
DEALLOCATE tb
GO
-----------------------------删除存储过程---------------------
DECLARE @au_lname VARCHAR(40),@SQLString NVARCHAR(500)
DECLARE tb CURSOR FOR
SELECT name FROM sysobjects WHERE xtype='p' and name like 'dnt%'
OPEN tb
-- Perform the FIRST FETCH.
FETCH NEXT FROM tb INTO @au_lname
-- CHECK @@FETCH_STATUS TO see IF there ARE ANY more ROWS TO FETCH.
WHILE @@FETCH_STATUS = 0
BEGIN
-- This IS executed AS long AS the previous FETCH succeeds.
FETCH NEXT FROM tb INTO @au_lname
SET @SQLString='DROP PROCEDURE '+ @au_lname
EXEC sp_executesql @SQLString
--DROP TABLE @au_lname
END
CLOSE tb
DEALLOCATE tb
GO



相关阅读:
abstract 是什么意思?
同一页面多个商品倒计时JS 基于面向对象的javascript
构建免受 FSO 威胁虚拟主机(三)
从Atlas到Microsoft ASP.NET AJAX - 序
添加Dropbox服务到系统右键菜单
ASP错误解决:800a003a错误
CSS教程:vlink,alink,link和a:link
如何解决组合框无法满足大量数据的选择问题?
erlang在linux下的编译
JavaScript 动态生成方法的例子
社区(php&&mysql)一
解决跨浏览器兼容的CSS编码准则
JQuery 学习笔记 选择器之四
大史记 Linux操作系统的历史及其发展状况
快速导航

Copyright © 2016 phpStudy |