How to delete tables?

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
User avatar
Registered User
Posts: 79
Joined: Sat Sep 24, 2005 9:30 am

How to delete tables?

Post by miurdock »


i want to delete tables.

i made this code, how to remove it?

Code: Select all

ALTER TABLE `phpbb_topics` ADD INDEX (topic_last_post_id);
ALTER TABLE `phpbb_forums` ADD attached_forum_id MEDIUMINT(8) DEFAULT '-1' NOT NULL;
Registered User
Posts: 17905
Joined: Wed Dec 22, 2004 1:14 am
Location: Woodstock, IL

Post by espicom »

You are not deleting tables, you are altering them. To be safe, with your current level of understanding, you are better served by using tools like phpmyadmin to do this. They will allow you to chose the index, column, or table to "drop" (the proper term) from a menu, then they will generate the proper SQL commands to do it.
Fixing 1016/1030/1034 Errors | (obsolete link) | MySQL 4.1/5.x Client Error | phpBBv2 Logo in ACP
Support requests via PM are ignored!
"To be fully alive is to feel that everything is possible." - Eric Hoffer

Return to “2.0.x Support Forum”