Toad World® Forums

Script - Schema Browser - Tables - Script


#1

Team,

Can you please share the script TOAD uses to generate the script of each tables in the schema browser?

Regards,

Stanis


#2

Toad doesn’t just run queries that produce a script as an output. We run a bunch of queries, (which you can see by clicking Database -> Spool -> Spool SQL), but then we build the script internally using the results of the queries.

If you want a “script to build a script”, do a google search on dbms_metadata.get_ddl.