Alex Balashov writes:
Most database APIs provide a way to expose the table definition as well, i.e. a list of column types and names.
that is what mysql describe and show statements do, but analyzing the output is not convenient (columns, types, attributes, index).
-- juha