Looks like I beat you to the answer by about 3 mins, thanks for answering though. :)
I have a follow-up though. The foreign key constraints are not getting created with "ON DELETE CASCADE" as expected. I tried this in both MSSQL and Postgres. Is this expected behavior? If so, is it possible to modify the FKs after they are reflected to set ondelete and onupdate as appropriate? My test code: http://paste.pocoo.org/show/399307/ And my output: CREATE TABLE blog_comments ( id INTEGER NOT NULL, blog_id INTEGER, CONSTRAINT blog_comments_pkey PRIMARY KEY (id), CONSTRAINT blog_comments_blog_id_fkey FOREIGN KEY(blog_id) REFERENCES blog (id) ) It would seem to be a reflection issue though, b/c if I create a table manually, the "ON DELETE CASCADE" is added correctly. On Jun 1, 8:36 pm, Michael Bayer <[email protected]> wrote: > sure, you'd use the "mock" executor as in the second example > here:http://www.sqlalchemy.org/trac/wiki/FAQ#HowcanIgettheCREATETABLEDROPT... > > On Jun 1, 2011, at 8:01 PM, Randy Syring wrote: > > > > > > > > > I'd like to be able to dump an MS SQL server's objects to text on the > > local file system. I have a working solution for views, stored > > procedures, and functions, but tables are a different story. Can i > > use SA's reflection and table creation abilities to write create table > > DDL to a text file? > > > -- > > 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 > > athttp://groups.google.com/group/sqlalchemy?hl=en. -- 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.
