Reformat T-SQL

Summarize Script

Analyze T-SQL Script

Outline Statements

Click images to play animated demo

• reformat T-SQL code with set of customizable rules

  The rules are grouped in layout templates that can be stored and later reused. The Quick Layout Template feature allow the developers of fast switching between layout templates and use the one that best suits the current circumstances. [...]

• analyze T-SQL code using set of staitc analysis rules

  Use the Analysis Script feature to can identify common performance,design and database objects naming problems in the T-SQL code. [...]

• summarize T-SQL script

  Transact-SQL Script Summary can improve readability and help the developers and database administrators to identify and analyze long SQL scripts. Using the Script Summary you can view and navigate through the hierarchically structured summary of all batches and statements in the current T-SQL script. [...]

• encapsulate T-SQL script as stored procedure or function

  Use the Encapsulate Script feature to generate script for creation of a new stored procedure,scalar function or inline table valued function from T-SQL code. [...]

• transact-sql statements outlining

  The statements outlinig feature surrounds each statement in the T-SQL scrip with outlining reactangle. [...]

• validate T-SQL syntax

  When a Transact-SQL syntax error is found in the SQL script, it is highlighted in the code editor and a tooltip describing the error is supplied. [...]

• change tokens case

  Uppercase, lowercase and capitalize keywords, identifiers, variables and predefined tokens like data types and functions. [...]

• change string and identifiers delimiter

  Delimiters layout rules can modify the way of the identifiers and strings delimited with double quotation marks are rewritten. [...]

• configure and store set of layout rules in layout template

  A configured set of layout rules can be stored in a layout template and later applied over T-SQL scripts. [...]

• quick switching between layout templates

  The QuickLayout Template feature allow the developers of fast switching between layout templates and use the one that best suits the current circumstances. [...]