Introduction
Connect
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
Create Databricks 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
Set Bind Variables
Edit SQL
Editor Shortcut Keys
View Result Sets
Compare Differences in Data
Export Data with One Click Export
Share Excel Linked Queries
Publish Data to Intelligence Central
Report
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
How to configure Toad to use Auth for sending SMTP Emails
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.
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 format a partial statement, select the SQL you want to format and click
Additional Details
- You can click
- 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.