Script - Schema Browser - Tables - Script


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



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.