Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - How to drop WWF dependencies?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

How to drop WWF dependencies?

 Post Reply Post Reply
Author
Savatage1 View Drop Down
Newbie
Newbie


Joined: 17 January 2004
Location: United States
Status: Offline
Points: 8
Post Options Post Options   Thanks (0) Thanks(0)   Quote Savatage1 Quote  Post ReplyReply Direct Link To This Post Topic: How to drop WWF dependencies?
    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.

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 20 January 2004 at 4:30am
Try deleting any relationships between the tables first.
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
Savatage1 View Drop Down
Newbie
Newbie


Joined: 17 January 2004
Location: United States
Status: Offline
Points: 8
Post Options Post Options   Thanks (0) Thanks(0)   Quote Savatage1 Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.