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 
>

-- 



Reply via email to