SQL Problem...DROP TABLE ACCOUNTS

[_Dreamer]

Hello,i want to delete table accounts but when i execute the command:

DROP TABLE accounts

i have this error

#1217 - Cannot delete or update a parent row: a foreign key constraint fails

Can anyone help me??? I want to delete it...

 

[Diazapam]

You have to delete players first and to do that you have to delete player_deaths etc...

 

[_Dreamer]

The same Problem :/

#1217 - Cannot delete or update a parent row: a foreign key constraint fails
DROP TABLE  `player_deaths`

 

[MiPo91]

Why you event want to delete accounts table? It's not like you could run server without it...

If you just want to erase all accounts in it Use Truncate option in phpmyadmin or if you want to add new contents use "ALTER TABLE" or you can do that also in phpmyadmin without any knowledge of SQL.