Autoformat should not indent begin
It should format as
for all cases where begin and end are used.
This is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
IndentBeginToken in config not changing anything (Beta 6.4).
My stored procedure code has 2 indents because of the starting BEGIN. Don't like it that way, wasting space...
Option is not in UI but we can modify it in:
c:\Users\<your login>\AppData\Local\Red Gate\SQL Prompt 5\RedGate_SqlPrompt_Format_Layout_LayoutOptions.xml
Change element IndentBeginToken:
Paul Nuttall commented
I always indent BEGIN END by 3 spaces
The code left aligns with the begin