I am looking to drop all indexes in a table, then prioritize some new ones.
How would I delete all, do I have to name all of them, or can I use a special character?
Code:
DoCmd.RunSQL "DROP INDEX Table1 ;" ' Remove indexes from Fields
DoCmd.RunSQL "CREATE INDEX Table1 [unique_id] Ascending, [equipment_item_id] Ascending, [platform_id] Ascending, [Role / FE / Node ID] Ascending;" ' Adds Index to Fields
Below I want to remove the red boxed ones and reprioritize the remaining, or remove all and make a new one prioritized in sequence as in the 2 line.
Thanks