Bonjour j'ai l'erreur suivante :

------------------------------------------------------------------------------

requête SQL:

IF EXISTS (
SELECT 1
FROM sys.sysforeignkey
WHERE role = 'FK_ADMINIST_ADMINISTR_ADMINIST ')
THEN
ALTER TABLE ADMINISTRER_CORRESPONDANT DELETE FOREIGN KEY FK_ADMINIST_ADMINISTR_ADMINIST END IF

---------------------------------------------

MySQL a répondu:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'if exists (select 1 from sys.sysforeignkey where role='FK_ADMINIST_ADMINISTR_ADM' at line 8

---------------------------------------------------

j'utilise phpMyAdmin-2.6.4(pl1) et mysql-essential-5.0.18

Apparement il n'aime pas le if exists ...

voilou