Foreign key constraints
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
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.