kosieh
13 lines
447 B
Python
13 lines
447 B
Python
from sqlalchemy import create_engine, inspect
|
|
|
|
engine = create_engine('sqlite:////home/kosieh/db.sqlite')
|
|
inspector = inspect(engine)
|
|
|
|
schemas = inspector.get_schema_names()
|
|
|
|
for schema in schemas:
|
|
print(f"Schema: {schema}")
|
|
for tableName in inspector.get_table_names(schema = schema):
|
|
print(f"Table name: {tableName}")
|
|
for column in inspector.get_columns(tableName, schema = schema):
|
|
print(f"Column: {column}") |