At 16:19 -0700 4/27/02, Vadim wrote: >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.
Right, there are none. > 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. From the .frm file. > Do users have any >access to it ? Yes, use the DESCRIBE statement. :-) (Or SHOW COLUMNS, which is synonymous.) > Also, can I write to that filed EXTRA (see the example >below) No. > ? 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
