Page 1 of 1

How to delete tables?

Posted: Tue Jan 16, 2007 12:40 pm
by miurdock
hello,

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;

Posted: Wed Jan 17, 2007 3:35 pm
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.