Need SELECT showing list of MySQL Data Dictionary objects

[DeepDiverMom]

I'm a MySQL newbie. I have a good deal of Oracle DBA experience. In Oracle, if I issue this SELECT:

SELECT object_name
from DBA_OBJECTS
where owner = 'SYS'
and object_name like 'DBA%';

...I get a listing of such helpful DBA views as:
DBA_USERS (all installation users)
DBA_TABLES (all tables no matter owner/schema)
DBA_VIEWS (all views no matter owner/schema)
et cetera

What query can I issue in MySQL that gives me the equivalent listing of data dictionary views for MySQL?

 

[sleipnir214]

You might take a look at MySQL's SHOW and DESCRIBE commands:

http://www.mysql.com/doc/en/SHOW.html

http://www.mysql.com/doc/en/DESCRIBE.html

User information on MySQL is stored in the "mysql" database on your server. A description of what can be found there is available here:

http://www.mysql.com/doc/en/GRANT.html

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[swampBoogie]

Well, as Mysql does not support views you can't use a select statement to get the information. Take a look at the show command in the docs at

http://www.mysql.com

 

[DeepDiverMom]

Thanks "sleipnir214" and "swampBoogie". I've read those docs and found that with the commands:
"USE mysql"
"show tables"
...that MySQL's equivalent of its data dictionary is composed of six tables:
columns_priv
db
func
host
tables_priv
user