Re: obtain primary keys

phph..._at_yahoo.es wrote:
> 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?

What I ment was:
since I have to change *dependent* 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:40:19 CST