Is there a simple way to export all table metadata (i.e. fields and
field data types)? I've been introduced to a DB with over 40 tables,
and I would like an easy way to diagram the fields without having to
manually input each table and its fields into a new spreadsheet or
Visio doc.

Thanks.

I'm not sure if it's the way you want it but have you tried
select * from Information_schema.columns
M