Press "Enter" to skip to content

How to Generate Schema Script from Toad?

To generate a schema script from Toad for Oracle follow these steps.

Generate Schema Script in Toad for Oracle

  1. In Toad, click on the menu Database > Export > Generate Schema Script option.
  2. The Generate Schema Script window will open.
  3. Select the schema from the left side list and provide the script file name at DDL filename field as shown in below image.

generate schema script in toad

  1. Then click on the Object Types tab and select the objects to include in schema script as shown in below image.

select objects for schema script in toad

  1. Then you can check other tabs also like Object Set, Filters and Script Options to specify more options. But I think you must check script options tab to find some useful settings for generating schema script.
  2. Then click on the Green Start button, and it will generate the schema script at the specified location.

See also:

Have you found the answer to your question? If not, you can discuss it with me in the comments section below or join my Q&A community for developers and ask your question. It is FREE.

Vinish Kapoor


Hi, I am a full stack developer and writing about development. I document everything I learn and help thousands of people. is created, written, and maintained by me; it is built on WordPress, and hosted by Bluehost. Connect with me on Facebook, Twitter, GitHub, and get notifications for new posts.

Inline Feedbacks
View all comments