>>>Hi All,
>>>
>>>while trying to fix a corrupted DBC I need to redo some indexes. There is just the DBC, nothing else. While I know to get the information about the tags via ATAGINFO(), how do I get information about foreign keys? This is odd. I know I can mimic low level through the DBC, but is there nothing build in?
>>>
>>
>>See if ADBObjects() gives you what you need.
>>
>>Tamar
>
>Hi Tamar,
>
>Yes, thank you this is the information I need.
>
>Ends up directly with the next question. How to programaticaly create referential integrity ? If the relation is lost integrity is lost too. ADBObjects() gives me waht to do, but I aside from hacking the DBC I have no chance. This is a database of 379 tables, 212 views, 96 relations - impossible to work this in MODI DATA .

Do you have Stonefield Database Toolkit? It does this, so you could look at Doug's code there.

To answer the specific question, look at the REFERENCES and FOREIGN KEY clauses of ALTER TABLE.

Tamar