Re: Foreign Key Renaming Problem

2004-05-13 Thread Heikki Tuuri
Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Wednesday, May 12, 2004 4:30 PM Subject: Re: Foreign Key Renaming Problem > "Deepak Vishwanathan" <[EMAIL PROTECTED]> wrote: > > I have a table named t1

Re: Foreign Key Renaming Problem

2004-05-12 Thread Victoria Reznichenko
"Deepak Vishwanathan" <[EMAIL PROTECTED]> wrote: > I have a table named t1 with a column x1 which is the primary key for > that table. There are some other tables that reference this table t1 on > x1 with foreign key constraints. > > > > I wanted to rename the column x1 for some reason, so, I went

Foreign Key Renaming Problem

2004-05-10 Thread Deepak Vishwanathan
Hi, I have a table named t1 with a column x1 which is the primary key for that table. There are some other tables that reference this table t1 on x1 with foreign key constraints. I wanted to rename the column x1 for some reason, so, I went ahead and renamed the column x1 to y1. I was able t