Subject Re: [firebird-support] How to list the tables and field wich use the primary key from one table as FK
Author Alan McDonald
You're implying that you have frequent enough cases of corruption to
warrant such an effort. Is this true?
Alan

On Monday, July 30, 2012, harveypekkar wrote:

> Hello ,
>
> I am trying to query the system table of firebird ( version 2.1) to
> obtain the list of table and fields wich use the primary key from another
> as foreign key , the goal is after a database corruption , and after having
> mend the corrupt records , to recopy from a backup with new ID and after
> updating in others tables using the ID as a reference by the new one ( I
> hope i'm clear enough !! ) , this part works fine but I want to automize
> the process a little and in case of a new table corruption , being able to
> list the table that use the primary key as a reference to refresh them .
> Best regards ,
>
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>

--
regards
Alan McDonald


[Non-text portions of this message have been removed]