Toad World® Forums

DDL Export - endings of tables, triggers,constraints

Hi Quest Team,

I use the Database/Export/Export DDL quite often lately. When exporting on file per object there the endings of some objecttypes like tables, constraints and triggers is .sql instead of .tbl, .trg. Other objecttypes like package get exported with ending like .pkg.

It is there an option to set the endings of the first group to the more specific ones. This would help me a lot when sorting the files afterwards.

Thanks in advance.

LG Martin


I don't think there is a way to do that in Export DDL, but there is a place to do it in Generate Schema Script. I hope that helps.


A software development company usually has specialized software developers who are committed to delivering the best products to their clients. These developers specialize in specific areas of software development, such as web and desktop software development. Web developers specialize in creating web applications and web pages through HTML, JavaScript, XML and PHP. Desktop software developers create software programs by for personal computers such as desktops, notebooks, netbooks and others. A desktop software development team may also specialize in specific areas of software development like wireless networking, automotive, consumer electronic, SaaS and manufacturing. A software development company will often have multiple product development teams working on a single project.

Ok, thank you its good enough

Oh, actually....I see we already export to Toad extension from Export DDL, as long as you choose the "One file per object" option. If there are some object types that we aren't making with the extension that you want, you can set that here: