SQLAlchemy Meta Reflection
examples/sqla/sqlite_meta_reflect.py
from sqlalchemy import create_engine import os #from sqlalchemy import inspect from sqlalchemy.engine import reflection dbname = 'test.db' if not os.path.exists(dbname): exit("Database file '{}' could not be found".format(dbname)) engine = create_engine('sqlite:///test.db') # inspector = inspect(engine) # print(inspector) # print(inspector.get_columns('address')) # print(inspector.get_foreign_keys('address')) insp = reflection.Inspector.from_engine(engine) print(insp.get_table_names())