Web Wiz Forums - remove SQL tables

Print Page | Close Window

remove SQL tables

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=28489
Printed Date: 02 April 2026 at 12:23am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: remove SQL tables

Posted By: p_watkins
Subject: remove SQL tables
Date Posted: 07 April 2010 at 12:06pm

I need to remove a version of WWF from an old server, now i've transfered the site.

What's the best way to remove the tables.

I've tried simply running DROP TABLE but it runs into foreign key problems.

What are all the relationships in the DB?

Can i remove all of them before i delete the tables?

Thanks for your help

Replies:

Posted By: WebWiz-Bruce
Date Posted: 07 April 2010 at 4:20pm

You need to remove the tables in the right order so that tables that are linked higher up and removed first.

However I usually just keep running the delete command against all the forum tables and it will slowly remove them all.

-------------
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: p_watkins
Date Posted: 07 April 2010 at 5:20pm

Thanks Bruce.

I'll just persevere for a while.