How do i get a list of all the catlogs in the database?

[avihaimar]

Thank you

 

[vacunita]

If by catalogs, you mean all the DB's that are running. you can issue the mysqlshow command from a command prompt or shell.

Look here:

http://dev.mysql.com/doc/refman/5.1/en/mysqlshow.html

----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[avihaimar]

I need a sql command that will return a list of all the catalogs (schema) under data base

 

[vacunita]

Same thing:

But add the name of the DB.

mysql_show name_of_db.




----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.