Toad World® Forums

export list of tables to CSV

i know i can use the report wizard to generate a list of tables but i want more than just the name. I want name, attributes such a foreign keys, primary keys. I think of those as constraints but TDM calls them something else. Basically i am trying to get some of the items in the all_constraints table in oracle.

Hi,

see this XSL template:
http://modeling.inside.quest.com/entry.jspa?externalID=2701&categoryID=407

Add it to the XSL folder under Toad Data Modeler directory. Then click Model - Report/XSL Transformation… and select the CSV output.

Regards,

Vaclav