Oracle User_indexes Translation To MySQL

I have Oracle query: SELECT index_name, table_name FROM user_indexes; Since user_indexes is Oracle-specific view, how can I translate it to MySQL? This is my try: DECLARE currrent

Solution 1:

In Oracle user_indexes view contains informations about the indexes stored in the schema of the currently connected user.

As in Mysql SCHEMA=DB, the select proposed by you can be considered equivalent to the select from Oracle's user_indexes view. Regards Giova