C
C
CheGevara2014-09-05 11:06:26
MySQL
CheGevara, 2014-09-05 11:06:26

How to remove all relationships between tables in a MySQL database?

Is it possible to remove all links between tables in the database (MySQL, InnoDB) with one command.
It is desirable that it would not be necessary to enter the name of the keys / links manually.
What for? - The database does not drop if there are connections, you have to handle it (I work through phpmyadmin), and there are a lot of tables
No direct access to MySQL, only phpmyadmin (hosting)

Answer the question

In order to leave comments, you need to log in

1 answer(s)
V
vdem, 2014-09-05
@CheGevara

SET foreign_key_checks = 0;

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question