Installation
System Requirements
Install Toad
Specify App Data Directory Location
Read-Only Installation
Install Toad Silently
Install Toad on Citrix Systems
Upgrade Toad
Upgrade Automation Scripts
Files Migrated During Upgrades
Uninstall Toad
Create Connections
Understand Toad Connections
Create Access Connections
Create Amazon Redshift Connections
Create BusinessObjects Connections
Configure DB2 Client Connections
Configure DB2 LDAP Support
Create DB2 Connections
Create Excel Connections
Create Google Analytics Connections
Create Hive Connections
Create Intelligence Central Connections
Create MySQL Connections
Create ODBC Connections
Configure Oracle LDAP Support
Create Oracle Connections
Create Oracle BI Connections
Create PostgreSQL ODBC Connections
Create Salesforce Connections
Create Snowflake Connections
Create SQL Server Connections
Create SSAS Connections
Create SAP Connections
Create SAP HANA Connection
Create Teradata Connections
Troubleshoot Connections
Troubleshoot Access Issues
Troubleshoot DB2 LUW Issues
Troubleshoot DB2 z/OS Issues
Troubleshoot Informix Issues
Troubleshoot MySQL Issues
Troubleshoot Oracle Issues
Troubleshoot SQL Server Issues
Configure Version Control
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.