how about:

    my $dbfields = $dbh->selectcol_arrayref ("SHOW COLUMNS FROM table"
+);
[download]

is even more MySQL'ish and gives all the details of the fields.

jdtoronto