Web Wiz Support and Community Forums : How to drop WWF dependencies? https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 07 Apr 2026 16:58:31 +0000 Fri, 23 Jan 2004 09:15:39 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=9049 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[How to drop WWF dependencies? : Well easy enough to drop all Constraints. BEGIN...]]> https://forums.webwiz.net/how-to-drop-wwf-dependencies_topic9049_post48652.html#48652 Author: michael
Subject: 9049
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

]]> Fri, 23 Jan 2004 09:15:39 +0000 https://forums.webwiz.net/how-to-drop-wwf-dependencies_topic9049_post48652.html#48652 <![CDATA[How to drop WWF dependencies? : I guess what I am asking for is...]]> https://forums.webwiz.net/how-to-drop-wwf-dependencies_topic9049_post48577.html#48577 Author: Savatage1
Subject: 9049
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.]]> Thu, 22 Jan 2004 22:12:14 +0000 https://forums.webwiz.net/how-to-drop-wwf-dependencies_topic9049_post48577.html#48577 <![CDATA[How to drop WWF dependencies? : Also if you do it a few times...]]> https://forums.webwiz.net/how-to-drop-wwf-dependencies_topic9049_post47935.html#47935 Author: michael
Subject: 9049
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. ]]> Tue, 20 Jan 2004 09:18:09 +0000 https://forums.webwiz.net/how-to-drop-wwf-dependencies_topic9049_post47935.html#47935 <![CDATA[How to drop WWF dependencies? : Try deleting any relationships...]]> https://forums.webwiz.net/how-to-drop-wwf-dependencies_topic9049_post47908.html#47908 Author: WebWiz-Bruce
Subject: 9049
Posted: 20 January 2004 at 4:30am

Try deleting any relationships between the tables first.]]> Tue, 20 Jan 2004 04:30:14 +0000 https://forums.webwiz.net/how-to-drop-wwf-dependencies_topic9049_post47908.html#47908 <![CDATA[How to drop WWF dependencies? : I am trying to wipe out a 5.5...]]> https://forums.webwiz.net/how-to-drop-wwf-dependencies_topic9049_post47887.html#47887 Author: Savatage1
Subject: 9049
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.

]]> Mon, 19 Jan 2004 21:20:42 +0000 https://forums.webwiz.net/how-to-drop-wwf-dependencies_topic9049_post47887.html#47887