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 .
>
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges