MySql MariaDatase INDEX

[mauri.menabue]

Hi all,
I would like to know how to remove an index on a MySql MariaDatase table.
To create an index, the 'UNIQUE' clause is used. How to delete an index?

how to build compound index INDEX ON CLI_COD + STR(CLI_FAT,12,2) + DTOS(date())
TIA
Maurizio Menabue

[vilian]

TO REMOVE
oCN:Execute("ALTER TABLE your_table DROP INDEX your_index")

TO CREATE
oCN:Execute("ALTER TABLE your_table ADD INDEX your_index(`field1`, `field2`)")

[mauri.menabue]

Hi all
Thank Vilian
is also possible : oCN:Execute("ALTER TABLE your_table ADD INDEX your_index(`field1`, `My_function()`)")

[vilian]

I think no.