Try: db._adapter.create_table(db.tablename,fake_migrate=True)
On Thursday, 11 October 2012 10:32:27 UTC-5, Alec Taylor wrote: > > Using OracleDB, how do I generate the raw SQL of my database schema? > > The documentation only shows how to generate SQL from selects, inserts > or deletes: > http://web2py.com/books/default/chapter/29/06#Generating-raw-sql > > Nothing is mentioned regarding getting the `CREATE TABLE` and related > schema creation commands. > > Honestly I would be able to use `db._lastsql` or even reverse-engineer > the database directly (using Oracle Data Modeller or similar); however > a more direct approach would be preferred. > > Thanks for all suggestions, > > Alec Taylor > --