Boyd, ----- Original Message ----- From: ""Boyd E. Hemphill"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Tuesday, May 25, 2004 5:02 AM Subject: innodb FK column rename
> All: > > What are the consequences of renaming a column in a child table that is > the FK to the parent? Will innodb remap or do I need to destroy the > relationship, index and column and recreate? InnoDB does not remap the constraint. You first have to remove the FOREIGN KEY constraint. Then rename the column and recreate the constraint. > I am using 4.0.13 > > Thanks for your time! > > Boyd E. Hemphill Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Order MySQL technical support from https://order.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
