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
>vadim@stripped
