Web Wiz Forums - How to drop WWF dependencies?

Print Page | Close Window

How to drop WWF dependencies?

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=9049
Printed Date: 07 April 2026 at 4:55pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: How to drop WWF dependencies?

Posted By: Savatage1
Subject: How to drop WWF dependencies?
Date Posted: 19 January 2004 at 9:20pm

I am trying to wipe out a 5.5 installation, and install 7.7 in it's place. In order to do so, I have to delete the old WWF tables and stored procedures. However, when I try to do this, Enterprise Manager complains about the dependencies.

Does anyone have a script I can use to delete these old tables to make room for the new ones? I would rather not have to create a new database.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 20 January 2004 at 4:30am

Try deleting any relationships between the tables first.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: michael
Date Posted: 20 January 2004 at 9:18am

Also if you do it a few times in a row, select all and delete it will eventually be successful. Reason being if you'd do in the right order the problem would not exist.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: Savatage1
Date Posted: 22 January 2004 at 10:12pm

I guess what I am asking for is an easy way/script to remove the dependencies so I can remove and recreate the tables and stored procedures. I was hoping there was a DROP option in the setup script, but I dont see anything.

Posted By: michael
Date Posted: 23 January 2004 at 9:15am

Well easy enough to drop all Constraints.


BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
ALTER TABLE dbo.tblPollChoice
 DROP CONSTRAINT tblPollChoice_FK00
GO
COMMIT
BEGIN TRANSACTION
COMMIT
BEGIN TRANSACTION
ALTER TABLE dbo.tblAuthor
 DROP CONSTRAINT tblAuthor_FK00
GO
COMMIT
BEGIN TRANSACTION
ALTER TABLE dbo.tblForum
 DROP CONSTRAINT tblForum_FK00
GO
COMMIT
BEGIN TRANSACTION
ALTER TABLE dbo.tblPermissions
 DROP CONSTRAINT tblPermissions_FK00
GO
ALTER TABLE dbo.tblTopic
 DROP CONSTRAINT tblTopic_FK00
GO
COMMIT
BEGIN TRANSACTION
ALTER TABLE dbo.tblThread
 DROP CONSTRAINT tblThread_FK01
GO
COMMIT
BEGIN TRANSACTION
COMMIT
BEGIN TRANSACTION
ALTER TABLE dbo.tblBuddyList
 DROP CONSTRAINT tblBuddyList_FK00
GO
ALTER TABLE dbo.tblEmailNotify
 DROP CONSTRAINT tblEmailNotify_FK00
GO
ALTER TABLE dbo.tblPMMessage
 DROP CONSTRAINT tblPMMessage_FK00
GO
ALTER TABLE dbo.tblThread
 DROP CONSTRAINT tblThread_FK00
GO
COMMIT
BEGIN TRANSACTION
ALTER TABLE dbo.tblGuestName
 DROP CONSTRAINT tblGuestName_FK00
GO

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker