I Wanted To Know, Can TOAD Data Modeller Generate A Report in Excel Format.
I Want All The Table Names And Their Attributes With Their Constraints.
Please Let me Know is There Any Way In TOAD To Get A Report in This Format in EXCEL Sheet.
you can generate CSV files from Toad Data Modeler.
Click Model | Reports/XSL Transformation…
New dialog opens. Choose item Entities (CSV) from the first combo box and click Transform.
This will generate a sample CSV file that can be opened in Excel.
The following file will allow you to generate more detailed report:
Feel free to modify the XLS file to generate desired output.
Thanks For Giving Me The Reply,But I Want Entities And Their Attributes And Constraints on Them in The Excel Sheet.
you can customize the XSL template easily, or, if you send me more details, ideally sample model and sample report, I will help you.
Term “Constraints” is too general for me. Tables can have check constraints, columns can have check constraints, relationships…
Herewith I Am Attaching My Sample Excel Sheet,How Actually The Report Should Look…
Hope You Could Help Me…
SAMPLE EXCEL SHEET.xls (17.5 KB)
there is a way how to get similar report, but it would require additional effort.
I published an article that shows how to generate word or excel reports via XSL transformation:
Another possibility you have is to use TDM freeware as a viewer for your models.