Formatting Code

dbForge Studio 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.

Configuring 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.

Formatting Your 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.

Semicolon Insertion

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

To insert semicolons, go to SQL Complete menu and click the Insert Semicolons option. Alternatively, hold Ctrl and press B and then C.