Hi,
Is there any way to create multiple indexes with a unique indexname in 1 single data definition query?
ex. CREATE INDEX myindex1 ON mytable(myfield1)
CREATE INDEX myindex2 ON mytable (myfield2)
Kind regards,
Karen
Hi,
Is there any way to create multiple indexes with a unique indexname in 1 single data definition query?
ex. CREATE INDEX myindex1 ON mytable(myfield1)
CREATE INDEX myindex2 ON mytable (myfield2)
Kind regards,
Karen
I think you will need 1 statement per index.
This is general format
You can create indexes in Access( see diagram below)Code:CREATE INDEX CREATE INDEX index_name ON table_name (column_name) or CREATE UNIQUE INDEX index_name ON table_name (column_name)
In Table design mode, go to indexes.
You can add and name multiple indexes, then save the table.
For demo, I added 3 indexes based on field hrs