怎么快速删除DiscuzNT痕迹
来源：爱站网时间：2022-03-09编辑：网友分享
有朋友想要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
不知道朋友们对怎么快速删除DiscuzNT痕迹的内容都掌握了没有，如果有不解的地方，来爱站技术频道网站咨询小编就可以了，小编会帮助大家解决问题。
上一篇：discuz运行环境的配置方法
