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

The Help file under ALTER TABLE has this:

REFERENCES TableName2[TAG TagName1]
Specifies the parent table to which a persistent relationship is established. The parent table cannot be a free table.

The TagName1 parameter clause specifies an index tag name for the parent table in TableName2. Index tag names can contain up to 10 characters. If you omit the TAG clause, the relationship is established using the primary index key of the parent table. If the parent table does not have a primary index, Visual FoxPro generates an error.

Under the Examples in that Help Topic:

* Example 4

ALTER TABLE Orders;

   ADD FOREIGN KEY Cust_id TAG Cust_id REFERENCES Customer