Hi
I guess then there is no way to use the Alter Table command to just create an additional index tag that is not related to any other table.
Thanks,
Simon
>>Hi
>>
>>I have been testing the Alter Table Command and it worked fine when I tried to create a candidate index tag but fails when I try to create a Foreign Key tag.
>>
>>I get a syntax error with following:
>>
>>Alter Table UPSystem Add Foreign Key Upper(Module+Name) Tag Name
>>
>>Where is the syntax error?
>
>You're missing the REFERENCES part of the ADD FOREIGN KEY clause that indicates what table it's a foreign key to.
>
>Tamar
Simon White
dCipher Computing