all_field.sql

select table_schema,
    table_name,
    column_name,
    column_type,
    is_nullable,
    column_comment
from information_schema.columns
where table_schema = '<database/schema name>'
order by table_schema, table_name, ordinal_position