Have op.create_table return a table object

[sqlalchemy-bot]

Migrated issue, originally created by Jon Black

op.create_table doesn't return anything, but it would be handy to have it return a table object that can be passed to op.bulk_insert.

The problem I had was that I learnt how to use create_table, then realised I needed to copy data from an old table, and found bulk_insert. It wasn't immediately clear that bulk_insert needs an object, and when I realised that, it was clear that the op.create_table route couldn't be used.

Many examples use sqlalchemy.sql.table to create the table, but it's not clear to me how constraints are added to those.

[sqlalchemy-bot]

Michael Bayer (@zzzeek) wrote:

yup, this is #205

[sqlalchemy-bot]

Michael Bayer (@zzzeek) wrote:

Duplicate of #205.

[sqlalchemy-bot]

Changes by Michael Bayer (@zzzeek):

• added labels: duplicate
• changed status to closed