Greetings: I'm a SYBASE DBA and very familiar with Sybase implementation of system catalog. (systables; syscolumns, etc) There is a lot of information that can be derived from these tables. MySQL, however, doesn't appear to have any system tables. When use command "describe" it shows the information some what similar to what Sybase's set of system tables would produce. The question is where does MySQL get this information. Do users have any access to it ? Also, can I write to that filed EXTRA (see the example below) ? I'm just trying to build a data dictionary based on the info MySQL's DESCRIBE command generates. Can anyone suggest a better way to create a data dictionary ? mysql> describe groupcode;
+-------------------+-----------------+--------+--------+-----------+--- ------+ | Field | Type | Null | Key | Default | Extra | +-------------------+-----------------+--------+--------+-----------+--- ------+ | group_code | varchar(30) | | PRI | | | | group_id | varchar(20) | YES | MUL | NULL | | :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::: Thank you very much for your time. Vadim Kulikov 877-428-3279 [EMAIL PROTECTED] --------------------------------------------------------------------- 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