Toad Data Studio 1.1

Chat now with support

Create Amazon Redshift Connections Create ODBC Connections Create Oracle Connections Create Snowflake Connections Create SQL Server Connections Create SharePoint Connections Understand Toad Connections Troubleshoot SQL Server Connections

Understand

Determine the Best Method to Locate Objects Object Explorer Filter Databases and Objects Understand a Table Using the Database Explorer Search for Objects Create an Database Diagram to Use as a Query Template Browse Data in Related Tables

Query

Tutorial: Build a Query Visually Create Cross-Connection Queries Reverse Engineer Queries Build a Subquery Edit SQL Editor Shortcut Keys View Result Sets Compare Differences in Data Export Data with One Click Export Share Excel Linked Queries

Automate

Getting Started with Automation Tutorial: Automate Excel Reports Automate Tasks Use Database Automation Activities Use File Automation Activities Use System Automation Activities Use Variables In Automation Execute/Schedule Automation Scripts

Format SQL

Use the Formatter to modify the layout of SQL in the Editor, including inserting a header block, adding or removing extra lines, and changing the case for keywords.

Click one of the following links to view a video about Basic or Advanced formatting features.

To preview the look and layout of the available formatting styles, go to Tools | Options | Editor | Formatter. See Formatter Options for more information.

To format SQL

In the SQL Editor, click the drop-down arrow beside and select a formatting style. Or select Editor | Format Code and select a style.
Then click to apply the style to the contents of the Editor window.
To format a partial statement, select the SQL you want to format and click to apply the specified style.

Additional Details

You can click in other editor windows to format code. The style currently specified in the SQL Editor (or in the Options dialog) is applied.
You can create a new custom template to use to format code in Tools | Options | Editor | Formatter. See Formatter Options for more information.
You can also specify custom formatting options for the available templates in Tools | Options | Editor | Formatter.
You can change or view the location where the formatting templates are stored in Tools | Options | Editor | Formatter.
To automatically format SQL you send from the Object Explorer to the SQL Editor, go to Tools | Options | Explorer | General and select Automatically format generated SQL. See General Explorer Options for more information.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Toad Data Studio 1.1 - User Guide

Format SQL