Erv, > Does MySQL have anything functionally equivalent to the data dictionary > views of Oracle? I am thinking particularly of retrieving, via a SQL > SELECT statement, a list of all my tables, or a list of all the columns of > a particular table along with the columns' attributes.
Installed as part of the MySQL DBMS, there is a database called MySQL containing a bunch of tables (similar to the Oracle structure) called user, db, and host (plus others). These control access to the db structure built up. The first manual note I came across on this topic was: 4.2.5 How the Privilege System Works In terms of viewing the table-contents of specific databases and the structure of the tables themselves, the SQL DDL (Data Definition Language) commands are discussed in various parts of Chapter 6 of the manual. However, in my experience using a DB Administration package is usually easier and faster. In native-SQL, these can be carried out without resorting to developing your own SELECT stmt. Does the combination of these answers cover what you wanted to know? =dn --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
