国产欧美二区三区-国产欧美高清-国产欧美国产精品第二区-国产欧美国产精品第一区-小说区图片区-小说区综合区都市激情

<abbr id="4oka8"></abbr>

<code id="4oka8"><tr id="4oka8"></tr></code>

<center id="4oka8"></center><dl id="4oka8"></dl>

<dl id="4oka8"></dl>

<rt id="4oka8"></rt>

快速刪除DiscuzNT論壇數(shù)據(jù)表和存儲(chǔ)過程

2017-02-21 17:02:41 小編：admin 分類：dz論壇信息來源：閱讀()

本來想一個(gè)一個(gè)刪除的，打開數(shù)據(jù)庫(kù)一看那么多的表和存儲(chǔ)過程，就放棄這種笨辦法了，于是決定用SQL語(yǔ)句來搞定。代碼如下：

-----------------------------刪除數(shù)據(jù)表---------------------

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

-----------------------------刪除存儲(chǔ)過程---------------------

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

此文由網(wǎng)站目錄_網(wǎng)站網(wǎng)址收錄與提交入口編輯，未經(jīng)允許不得轉(zhuǎn)載！：

相關(guān)文章

<rt id="4qcs8"><acronym id="4qcs8"></acronym></rt>

<del id="4qcs8"><fieldset id="4qcs8"></fieldset></del>