Columns of MySQL ENUM or SET types show in the generated report as only 'enum' or 'set'. It would be usefull if the full field definition was shown, eg: set('123',abc','zyx')
Ugh, that approach makes it extremely difficult to extract that information in a db vendor-independent manner. I'd have to parse through the returned resultset in a MySQL-specific manner, right?
John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Logged In: YES
user_id=1264584
Originator: NO
Sounds like a useful enhancement. Would you happen to know the SQL to extract that info?
John
Logged In: YES
user_id=907094
Originator: YES
"show create table the_table_name;"
Can return data like:
... `LineItemType` enum('scan','dept-sale','discount','coupon') default NULL ...
or
... `ApplicableTaxes` set('1','2','3','4','5','6','7','8') default NULL ...
http://dev.mysql.com/doc/refman/5.1/en/show-create-table.html
Logged In: YES
user_id=1264584
Originator: NO
Ugh, that approach makes it extremely difficult to extract that information in a db vendor-independent manner. I'd have to parse through the returned resultset in a MySQL-specific manner, right?
John
I was just "a little" slow in solving this, but can you try the beta: http://schemaspy.sourceforge.net/schemaSpy.jar
Thanks,
John