Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    10

    Unanswered: indexes info in MySQL

    Hi! All,

    I am in a process of switching from Oracle to MySQL. Is there a view in MySQL where i can see what indexes are built on which columns for a table. Something like user_indexes view in Oracle? Quick help highly appreciated

    Thanks.

  2. #2
    Join Date
    Dec 2003
    Posts
    10
    I got the solution
    show index from <tablename>

    Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •