Existing SQL
Review & Update SQL
Break an existing query into tables, columns, and relationships, then update its output structure.
Steps
1
Add the existing SQL
Paste or upload the script in the Imported SQL workspace.
2
Open Output Columns
See each returned column and the table or expression it comes from.
3
Open Review schema and update SQL
Review the detected tables, columns, keys, and relationships.
4
Apply structural changes
Remove or hide output fields, or use Add from Database to introduce reviewed tables and columns.
5
Check the revised output
Open Output Columns again and test the updated query.
Learn more
Guide: Review and update existing SQLOpen the relevant SQL Mocker tool
Continue with this workflow in SQL Mocker when you are ready.