Hello everybody, I am writing a component of an application that should display a chart of database tables and foreign keys (this one <https://github.com/mara/mara-db/tree/schema-ui-engine-agnostic>), and trying to make it database agnostic. I encountered a strange behavior when inspecting the foreign keys of a SQLite database, in particular I can't see them by setting schema_name to the value returned from get_schema_names but only by passing schema_name=None.
I create a test db this way: conn = sqlite3.connect('test.db') conn.execute('CREATE TABLE table_one(column_one INTEGER, column_two TEXT)') conn.execute("""CREATE TABLE table_two( column_X INTEGER, column_Y TEXT, FOREIGN KEY(column_X) REFERENCES table_one(column_one) )""") conn.close() If I use a sqlite database I see that inspect(engine).get_schema_names() returns *['main']* and sa.engine.reflection.Inspector.from_engine(db).get_table_names('main') shows the tables in the database, as expected. But when I run sa.engine.reflection.Inspector.from_engine(db).get_foreign_keys('table_name', schema='main') it doesn't return any foreign key, while it does with *schema=None* is this a bug or the expected behavior? -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.