Drop constraints only if it exists in mysql server 5.0

Question

i want to know how to drop a constraint only if it exists. is there any single line statement present in mysql server which will allow me to do this.

i have tried the following command but unable to get the desire output

alter table airlines 
drop foreign key if exits FK_airlines;

any help to this really help me to go forward in mysql

score 1 · Answer 1 · answered Feb 13 '09 at 07:15

1

I do not believe this is possible in a single line, unless you are willing to detect the error and move on (not a bad thing).

The INFORMATION_SCHEMA database contains the info you need to tell if the foreign key exists, so you could implement it in a 2 step process.

answered Feb 13 '09 at 07:15

gahooa

I'm willing to 'detect the error and move on' OR to use a '2 step process', but unfortunately the link you offer is not enough to get me there - could you elaborate please? – ilasno Nov 07 '13 at 00:46

score 0 · Answer 2 · answered Jun 26 '13 at 10:10

yep 2 step process is a good way like gahooa said

2 Answers2