Hi,
>I'm wondering where I can specify that the tables that I want are in
>the schema DataTables instead of 'dbo'. The engine.echo outuput shows
>
>
It's an argument to Table() e.g.
ke_contracts = Table('KEContracts', sa.metadata,
autoload=True, schema="DataTables")
>Second, the database that I connected to has tables in both the dbo
>and DataTables schema, yet my code to list tables, actually lists no
>tables.
>
>
Off the top of my head, I think table_iterator just lists the tables SA
knows about, not the tables in the database.
>sqlalchemy.exceptions.NoSuchTableError: KEContracts
>
>
Were you expecting this error? If not, I suggest running the query SA
produces by hand (in SQL Management Studio, or something) to see what
that produces. I will warn you now that MSSQL support still has a little
way to go!
Best wishes,
Paul
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
