Query Builder, a tool built into Toad, now supports the reverse engineering of queries which is limited. Quest offers another standalone application "Toad Data Modeler" which specializes in these features. Please visit this link for more detail on the "Toad Data Modeler": http://www.quest.com/Toad_Data_Modeler/.
The query must be a query that originally could have been created in the Query Builder. If the Query Builder could not create the original query, the reverse engineered query may be flawed. At this time, Toad cannot reverse engineer a query with nested sub-queries, although the Query Builder can create them.
Toad can reverse engineer:
. Select
. Insert
. Update
. Delete
queries, one at a time.
To reverse engineer a query
1. Enter a query into the Editor
Or
Open a file containing a query in the Editor.
2. Right-click in the query and select Send to Query Builder.
Workaround for reverse engineer for a View:
1. Go to your Schema browser | View tab
2. Select a View and go the Script tab
3. Copy the Select query from the script
4. Paste the query into the Editor
Or
Open a file containing a query in the Editor.
5. Right-click in the query and select Send to Query Builder.
NOTE: Although it was heavily tested throughout its development lifecycle, due to the vast array of possible queries there may be some queries it can create but cannot reverse. We encourage users to inform Quest if they discover such queries.
