>I have been trying to use the ALTER TABLE command to create a new non-primary index on a table contained in a database container. I followed the example from the Help screen and the Developer's Guide, but every time I try to code the command in a PRG and try to save it (with the Compile option upon Save) I get a Syntax Error so I can't even save the PRG file.
> Am I missing something? Does anyone have input that could help me get past this problem? Any feedback would be greatly appreciated.
>
> Rudy Nieves
> FOCUS Computer Management & Consulting
ADD FOREIGN KEY would be used to programmatically add a persistent relationship between two tables in a DBC. The complete syntax needs the .. REFERENCES parent_table TAG parent_primary_key. As B.Paltiel said, if you need non-primary index in this table INDEX ON .. TAG .. will suffice.