Re: How to delete a table

[Preston McMurry]

You don't need to drop the whole table to rename one field within that table. (Though if the field is a primary or foreign key, you want to be cautious about renaming it.) For instance, this is the command myPHPAdmin generates when I rename a field:

ALTER TABLE `dog` CHANGE `dog_idd` `dog_id` BIGINT( 20 ) NOT NULL AUTO_INCREMENT ;

Note that it won't work unless you include the information about the datatype, whatever that information may be in your case.