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.
Before you format your code, you might want to configure formatting options and customize case formatting profiles. To tune formatting options:
To format the whole code of a document do one of the following:
To format current statement:, do one of the following:
To format a certain code fragment:
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.