Understand SQL queries with the help of this tool #SQL query #SQL table #Parse SQL #SQL #Query #Table
Reverse Snowflake Joins, revj, for short, is an utility designed to help you understand SQL and document SQL queries.
This is especially good for maintaining big queries written by somebody else. "Big SQL" can be as many as 20 tables, joined by multiple fields.
Parts of the query appear directly in the diagram: Ex age=30 , GROUP BY (year), HAVING MIN(age) > 18 .
Getting these queries right is difficult because many tools generate poor SQL when dealing with complex joins. Manually written SQL is also error-prone, for example one might forget to remove a table if it is no longer needed to filter/group by one field in that table.
If there are disconnected tables it means there is a cartesian product. There are legitimate cases for cartesian products, however these cases are not common.
What's new in Reverse Snowflake Joins 0.48 Beta:
- Fixed union all. Ex: "select t1.a from T1 union all select t2.b from T2 union all ..". Fixed functions without parameters and parens, ex: "Select .. where t1.x=sysdate"
Reverse Snowflake Joins 0.48 Beta
add to watchlist add to download basket send us an update REPORT- runs on:
- Windows All
- file size:
- 81 KB
- main category:
- Internet
- developer:
- visit homepage
Context Menu Manager
ShareX
Windows Sandbox Launcher
7-Zip
IrfanView
Microsoft Teams
Bitdefender Antivirus Free
calibre
Zoom Client
4k Video Downloader
- calibre
- Zoom Client
- 4k Video Downloader
- Context Menu Manager
- ShareX
- Windows Sandbox Launcher
- 7-Zip
- IrfanView
- Microsoft Teams
- Bitdefender Antivirus Free