Hi

When reading the documentation it said

ADD FOREIGN KEY [ eExpression5] TAG TagName4[FOR lExpression6] 
Adds a foreign (non-primary) index to the table. The eExpression5 parameter specifies the foreign index key expression. The TagName4 parameter specifies the name of the foreign index tag. Index tag names can contain up to 10 characters.

The phrase "(non-primary) index" is what caused me to think this might be possible so I apologize for the misleading subject. I was not certain from the start whether I had read the documentation correctly and so the reason for my question.

Thanks,
Simon


>Well then the title is a tiny little wee misleading :)
>
>AFAIK there is no alternative to INDEX ON, same with SQL Server (that I know) where you need to use the CREATE INDEX statement. IOW, you cannot use the ALTER TABLE to create a regular index (you can create unique, primary and foreign), of course the other possibility is that I am wrong, in which case I appologize
>
>
>>All I want to do is add a new index tag to the UPSystem table so there is no reference to a master table basically all I wanted was the equivalent of:
>>
>>

>>Index On Upper(Module+Name) Tag Name
>>

>>
>>However I could not see just how that might done using the Alter table .
>>