Manage Relations – Delete

[Ritesh]

Quote:

I can see two problems in that transcript. One is about creating a temporary table (the one that stores my data to be inserted back into my real table after reconstruction) “if not exists”, so if it does exist I guess I'd get supplemental data that wasn't there before… I guess something like “DROP TABLE IF EXISTS” would be safe.

We use if not exists so that we dont delete an existing table (which might be important) by mistake.

Quote:

Second, at least MySQL 4.1 knows about this, which is safer and needs no warning 11 point warning from SQLyog:

SQLyog v4.1 BETA actually checks for MySQL version and uses the correct method. For e.g. if MySQL version is 4.1.x then it will use ALTER TABLE Test1 DROP FOREIGN KEY `Test1_ibfk_1` statement. Otherwise it will go for the original 11 steps method to drop the FK.

[Author]

Posts