Options for formatting your code - SQL Prompt

To set formatting options, on the SQL Prompt menu, select Options. The formatting options are all available in the Format group:

FormatOptions

Note: If you are using SQL Prompt Standard Edition, the format pages are unavailable; but you can set a number of options for how inserted code is formatted on the Basic (Standard Edition) page:

StandardOptionsPage

To review the effect of any changes you make, use the Preview tab:

The Sample SQL view shows how an example query would be formatted using the current options.
The Current Query view shows how the first few lines of the query that is currently active in the editor window of your SQL editing application (eg SQL Server Management Studio) would be laid out using the current options.

Case

Case options are available in both Standard and Pro Editions of SQL Prompt:

In Standard Edition, case options are on the Format > Basic (Standard Edition) page
In Pro Edition, case options are on the Format > Case page

Selecting UPPERCASE or lowercase will replace any words you have typed with the selected case, and also insert any suggestions using the selected case.

For example, if UPPERCASE is selected:

If you have already typed select or Select in your query, SQL Prompt replaces the word with SELECT.
If you type sel or Sel and then insert SELECT from the suggestions box, SQL Prompt inserts SELECT.

Selecting Leave as is will leave the case of any letters you have already typed, but insert the remainder of the word using the case of the last typed letter.

For example:

If you type the entire word Select, SQL Prompt leaves the word exactly as typed.
If you type Sel, SQL Prompt will insert Select.
If you type SEL, SQL Prompt will insert SELECT.

Changing the case in pasted code

When you paste code into your query editor, you can apply your preferred case to that code. This is only available in SQL Prompt Pro Edition.

Set the case options for keywords, functions, and data types as required on the Format > Case page of the SQL Prompt Options dialog box.
Click OK to save these settings.
In your query editor, select all the lines of code to which want to apply the case.
On the SQL Prompt menu, select Format SQL.

Note: This will also apply all other format settings (such as indentations, new line settings, and so on) to that code.

Schema statements

Options for formatting new lines and indents in CREATE and ALTER statements.

Data statements

Options for formatting new lines, parentheses and indents in SELECT, INSERT, UPDATE and DELETE statements.

Expressions

Options for formatting parts of statements, for example how Boolean and other types of operators should appear.

Commas & parentheses

Options for formatting where commas should appear in your SQL statements (at the end or beginning of lines), and how they should align with other lines of code.