[Sqlalchemy-tickets] Issue #3261: sqlite backend ignores names on foreign key constraints (zzzeek/sqlalchemy)

[Mike B. <iss...@bi...>]

New issue 3261: sqlite backend ignores names on foreign key constraints
https://bitbucket.org/zzzeek/sqlalchemy/issue/3261/sqlite-backend-ignores-names-on-foreign

Mike Bayer:

this is to complement #3244.  While for UNIQUE, we use `.schema` to get at the unique constraints, therefore we have the names, for FOREIGN KEY we use `.pragma` which does *not* give us the names, however `.schema` does.  Foreign key reflection should therefore be rewritten to use parsing of `.schema`, however at the same time I'd like to keep the `.pragma` call in place as well as a means to double check what we get back.

this is also critical for Alembic support.