CODEWITHSUNDEEP
mysqlsqloracle-databasemigration
Benas
Benas

Reputation: 2332

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 currrentDB      VARCHAR(64);
SELECT DATABASE() INTO currrentDB;
SELECT  INDEX_NAME, TABLE_NAME FROM information_schema.statistics s
        WHERE UPPER(s.TABLE_SCHEMA) = UPPER(currrentDB);

Are these two SQL statements are equivalent?

Upvotes: 3

Views: 334

Answers (1)

Giova
Giova

Reputation: 1127

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

Upvotes: 1

Related Questions