How to delete a table in mysql using query [Resolved]

Posted by Amritha444 under ASP.NET on 12/18/2010 | Points: 10 | Views : 1899 | Status : [Member] | Replies : 1
How to delete a table in mysql using query.Because i cant view particular table called sale in database but when i tried to create new table in the same name it results in error.why like this happens.Any other solutions

Thanks in advance




Responses

Posted by: SheoNarayan on: 12/19/2010 [Administrator] HonoraryPlatinum | Points: 50

Up
0
Down

Resolved
The syntax to drop (delete) a table in MySql is

DROP TABLE Sale;


More on MySql delete, read http://dev.mysql.com/doc/refman/5.5/en/delete.html

Thanks

Regards,
Sheo Narayan
http://www.dotnetfunda.com

Amritha444, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response