手机
当前位置:查字典教程网 >CMS教程 >discuz >快速删除DiscuzNT论坛数据表和存储过程
快速删除DiscuzNT论坛数据表和存储过程
摘要:本来想一个一个删除的,打开数据库一看那么多的表和存储过程,就放弃这种笨办法了,于是决定用SQL语句来搞定。代码如下:------------...

本来想一个一个删除的,打开数据库一看那么多的表和存储过程,就放弃这种笨办法了,于是决定用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

【快速删除DiscuzNT论坛数据表和存储过程】相关文章:

集中删除discuz!论坛垃圾广告的技巧

Discuz! X2.5论坛标题字数突破80的限制实现思路

discuz修改太阳、月亮、星星等默认等级图标的方法

Discuz论坛宣传与优化技巧概述

Discuz论坛发帖技巧分享

教您为Discuz!论坛轻松更换风格

查看discuz!论坛管理纪录

discuz 7.2论坛 用户名、密码、数据库名修改方法

Discuz!7.0论坛帮助功能详解

火车头 Discuz-X 1.0 论坛免登陆发布接口

精品推荐
分类导航