Skip to content

Latest commit

 

History

History
14 lines (11 loc) · 878 Bytes

README.md

File metadata and controls

14 lines (11 loc) · 878 Bytes
Raw

TsqlScriptDom

A simple GUI tool to help use Microsoft.SqlServer.TransactSql.ScriptDom

I created this tool when I was learning on how to use the library to analyze T-SQL scripts. It basically contains a treeview to show the hierarchical structure of the SQL scripts, showing each fragment's properties, and generating formatted SQL scripts.

Usage

  • You can pipe SQL scripts to the tool by using "select * from foo" | TsqlScriptDom.exe -
  • You can pass multiple SQL files to the tool from command line
  • You can drag & drop files onto the SQL script pane
  • You can open a new window by select some SQL scripts to parse them alone
  • Select a tree node will also select the corresponding SQL scripts in the editor
  • Double click a location in the editor, or use menu item "Tools/Locate in Tree" to locate the corresponding node in treeview