如何从sqlalchemy中的session/engine/meta获取表名及其数据类型？

from sqlalchemy import create_engine, inspect, MetaData
from sqlalchemy.orm import sessionmaker

engine = create_engine('数据库连接字符串')

Session = sessionmaker(bind=engine)
session = Session()

metadata = MetaData(bind=engine)
metadata.reflect(bind=engine)
inspector = inspect(engine)

table_names = inspector.get_table_names()

for table_name in table_names:
    table = metadata.tables[table_name]
    columns = table.columns
    column_names = [column.name for column in columns]
    column_types = [column.type for column in columns]
    print("表名:", table_name)
    print("列名:", column_names)
    print("数据类型:", column_types)
    print("--------------")