Is there are unified way of how to check for the existance of an INDEX for a given column irregardless of the actual SQL database system used?
For MySQL one could for instance check for the existance using
SHOW CREATE TABLE mytable. In the result there would be something like this if column
mycolumn has an index:
KEY 'Index_1' ('mycolumn').
Is this indicator
KEY unified among all SQL database systems?
Are there better ways to check for an index?