>>>>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

Hi Tamar,

No, I don't have Stonefield. And on help to ALTER TABLE I do not see how to set referential integrity, as far as I understand it. Searching for referential integrity in help reveals nothing aside the use of interface.

Lutz