Re: RE : Dropping foreing key without losing data

2003-02-01 Thread Zak Greant
On Fri, Jan 31, 2003 at 08:46:53AM +0100, Webmaster LLBfrance wrote: > Hello Zak, > > Thanks for your response. > I try the way you told me, but it seems there is > another problem : > The old foreign keys always exist. > In consequence, there are double references. > > How can i resolve that pro

RE : Dropping foreing key without losing data

2003-01-31 Thread Webmaster LLBfrance
reant [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 30 janvier 2003 23:16 À : Webmaster LLBfrance Cc : [EMAIL PROTECTED] Objet : Re: Dropping foreing key without losing data On Thu, Jan 30, 2003 at 10:08:08AM +0100, Webmaster LLBfrance wrote: > Hello, > > Can you tell me how to drop or

Re: Dropping foreing key without losing data

2003-01-31 Thread Zak Greant
On Thu, Jan 30, 2003 at 10:08:08AM +0100, Webmaster LLBfrance wrote: > Hello, > > Can you tell me how to drop or desactivate a foreign key without > losing any data in SQL for MySQL 3.23.51 ? Hello JeanClaude, Unfortunately, foreign keys cannot currently be conveniently dropped. :( The Inn

Dropping foreing key without losing data

2003-01-30 Thread Webmaster LLBfrance
Hello, Can you tell me how to drop or desactivate a foreign key without losing any data in SQL for MySQL 3.23.51 ? Thanks in advance. JeanClaude - Before posting, please check: http://www.mysql.com/manual.php (the manual)