"Lou Olsten" <[EMAIL PROTECTED]> wrote: > I'm in the process of trying to move some of our systems to MySQL from SQL Server and > Oracle. At this point I'm learning and testing MySQL. > > One immediate question I have is regarding getting aggregate information. For > example, > the SHOW DATABASES command would be an example of something I would get from the SQL > Server data dictionary table, sysdatabases. It appears that MySQL has no such > mechanisms, and that you must rely on many of the SHOW commands. In the case of > databases, it works great, but what about other objects? > > For example, if I want to see all indexes in my sales database? Or do I have to loop > through each table with the SHOW INDEXES command? That's one example of what I'm > talking > about.
Yes, in this case you should execute SHOW INDEX for each table from your database. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
