MySQL Forums
Forum List  »  Stored Procedures

Foreign key constraints
Posted by: harjeet singh
Date: April 08, 2012 11:28PM

I want to change the primary key column datatype from smallint to mediumint which is familiar with many table as foreign key constraints when i go for change in child table either parent table then error occured #1025 - Error on rename of '-------. i can do it only, to break the relation of first table then second table and so on but this is very time consuming, could anyone help me on this problem

Options: ReplyQuote


Subject
Views
Written By
Posted
Foreign key constraints
1798
April 08, 2012 11:28PM
790
April 09, 2012 03:26AM
932
April 09, 2012 04:05AM
835
April 09, 2012 11:47AM
876
April 09, 2012 10:21PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.