Salesforce SQL Editor
The Salesforce SQL editor allows users to write SQL select, update, insert, and delete statements against Salesforce.com databases. Users can run SQL commands manually or with a click of the mouse. Auto completion and auto lookup for tables and columns is provided. The editor also supports many languages other than SQL such as HTML, XML, Java, JavaScript, PHP and many more. Listed below are the main features of the Salesforce SQL editor. For information on the SQL syntax supported by the editor, please see the following: RazorSQL Salesforce SQL Support.
SQL Editor Features
- SQL syntax highlighting
- Auto table lookup and completion
- Auto column lookup and completion
- Extensive find, replace, and find / replace in files functionality
- Bracket, parenthesis, and brace auto matching
- Support for parameterized queries
- SQL Formatter
- Execute, Execute Fetch All, and Execute Batch functions
- Multi-Tabular Display of Query Results
- Sortable Query Results
- Filterable Query Results
- Searchable Query Results
- SQL History for All Queries, and Query Logging Per Connection
- Query navigator for displaying a clickable display of queries in the editor
- Key Ahead functionality for one-click population of user-defined text
- Built-in and Custom User Templates
- Plugin API (Allows users to add custom functionality to RazorSQL)
