I don't think you want to try to dup the table, then delete columns.
Instead just create the new table, with only the columns you want.
Try this:

emp2 = Table('emp2', metadata)
for c in emp.columns:
  if c.name != 'hiredate':
    emp2.append_column(c.copy())
emp2.create(engine)

Thanks Jonathan, your example is more readability than mine.

- sS


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to