Correction:
>
>ALTER TABLE is only for adding and dropping primary and foreign keys. Youhave to use the INDEX ON CODETYPE TAG CODETYPE command.