Re: obtain primary keys

From: <phph109_at_yahoo.es>
Date: 11 Feb 2005 05:35:05 -0800
Message-ID: <1108128905.246454.273700@f14g2000cwb.googlegroups.com>

fitzjarrell_at_cox.net wrote:
> Let us not forget foreign keys referencing the currently defined
> primary key as they are likely to be invalidated by the change. One
> needs to find all foreign key constraints and change those column
> definitions as well.

Aah, thanks for pointing that out!

But since I have to change refering columns as well, maybe they becomes valid again?

Whatever, would this help me track them? select * from sys.all_indexes where status != 'VALID' and owner = 'PH'

--ph Received on Fri Feb 11 2005 - 07:35:05 CST