Contents

How to format SQL code in dbForge Studio for SQL Server

dbForge Studio for SQL Server can help you to format your SQL statements, paying attention to case, line breaks, whitespaces, indenting, wrapping, etc. Statements with errors are skipped and are not formatted.

THe guide describes the following topics:

• Configure formatting options
• Format code
• Formatting errors
• Semicolon insertion

Configure formatting options

Before you format your code, you might want to configure formatting options and customize case formatting profiles. To tune formatting options:

1. On the Tools menu, point to Options. The Options dialog box opens.
2. On the Options dialog box, navigate to Text Editor, Formatting.
3. Apply required changes. For more information, refer to the Formatting topic.

Format code

To format the whole code of a document do one of the following:

• On the Text toolbar, click Format Document.
• Press Ctrl+K,D.

To format current statement:, do one of the following:

• On the Text toolbar, click Format Current Statement.
• Click Format Current Statement on the SQL Editor shortcut menu.
• Press Ctrl+K,S.

To format a certain code fragment:

1. Highlight a required code fragment.
2. Click Format Selection on the SQL Editor shortcut menu. Alternatively, press Ctrl+K,F.

Formatting errors

The Studio can format only complete code blocks. Applying formatting to a code fragment, for example, a part of a query or a single line of code, will result in a syntax error.

Semicolon insertion

You can use dbForge Studio for SQL Server to insert missing semicolons after each statement in a query.

To insert semicolons, right-click the statement body, point to Refactoring, and then click the Insert Semicolons option. Alternatively, hold Ctrl and press B and then C.

Download dbForge Studio for SQL Server and try it absolutely free for 30 days!

Want to Find out More?

• Previous
• Next