Main Editor Features
  
Automatic Function Lookup:

The RazorSQL sql editor contains function information for SQL, PL/SQL, TransactSQL, and SQL PL. By invoking the function lookup command, all functions will be displayed for the currently selected language. RazorSQL also supports Java method lookup. Java method lookup happens automatically after typing a period (.) after a variable name of Java class name. Function lookup is also provided for other programming languages supported by RazorSQL such as C, C++, JavaScript, PHP, etc.

Key Ahead:

The RazorSQL sql editor contains key ahead functionality. Key ahead allows users to quickly insert customizable text into the sql editor by simply typing a shortcut key - control key + k.

Key ahead works by looking at the previous letter typed in the sql editor at the time the shortcut key is pressed. If there are no letters in the position previous to the cursor, the complete key ahead list will be displayed on the screen. The user can then select the key ahead entry to be inserted into the editor. If there is a letter in the position previous to the cursor, the key ahead list is filtered to display only those entries that start with that letter.

Key ahead can be customized by going to the preferences menu (Edit -> Preferences).

Automatic Column Lookup:

The RazorSQL programming editor supports automatic column lookup. If a database connection is present, and a period (.) is typed in the sql editor, RazorSQL tries to determine if the period has been typed after a table name or an alias to a table name. If RazorSQL determines this to be the case, RazorSQL will display a list of all of the columns for the table.

To guarantee the correct execution of automatic column lookup, the full table name should be typed prior to the period. If using aliases, to guarantee correct execution of automatic column lookup, do not refer to different table names by the same alias in the sql editor.

Automatic column lookup can be customized in the preferences menu (Edit -> Preferences). It can be turned on or off, and the amount of time RazorSQL will wait before doing the lookup after a period is typed can be customized.

Automatic Table Lookup:

The RazorSQL programming editor supports automatic table lookup. If a database connection is present, a keyword such as from or update is typed, RazorSQL will perform a call to get all tables for the current user and display a window with all tables at the cursor position.

Automatic table lookup can be customized in the preferences menu (Edit -> Preferences). It can be turned on or off, and the amount of time RazorSQL will wait before doing the lookup can be customized.

Zip Utility:

The Zip Utility allows users to view and/or extract individual files or all files contained in Zip or Jar files.

Match Tag:

The Match Tag tool highlights the text from the next begin tag to the next matching end tag after the next begin tag.

Match Bracket:

The Match Bracket tool the text from the next open bracket to the next matching closing bracket after the next open bracket. The following brackets are supported (), {}, [].

File Compare Tool:

The File Compare Tool compares two files and prints out a report detailing the differences in the files.

Find/Replace, Find/Replace in Files:

These tools find or replace text in the current open editor, or find/replace text in files in the file system.

File System Browser:

The File System Browser allows users to browse their file system in an explorer like interface. Users can create directories, rename files/directories, delete files, view files, etc.

   Editor Commands
  
Execute SQL:

This command executes an sql statement contained the in sql editor. If there is an sql statement highlighted, that statement will be executed. If there are no sql commands highlighted, this command will try to determine the statement to be executed based on the placement of semi-colons. If there are multiple statements in the editor, and the statements are separated by semi-colons, RazorSQL will execute the closest statement to the cursor position. If statements are not separated by semi-colons, this command will try to execute the entire contents of the sql editor as one statement call.

The fetch size of the Execute SQL command can be customized in the preferences menu (Edit -> Preferences). By default, RazorSQL uses the database driver settings for the fetch size. Fetch size is simply the number of rows returned from the database per network call. If a database table has 500 rows, and the fetch size is 100, 5 network calls would be made to see all rows in the database. In this example, the extra network calls would only be made if the user scrolls past each 100 row mark on the results table.

Execute SQL Fetch All Rows

This command executes an sql statement contained the in sql editor. If there is an sql statement highlighted, that statement will be executed. If there are no sql commands highlighted, this command will send the contents of the sql editor to the database.

The Execute SQL Fetch All Rows command fetches all rows from the database table and displays all rows in the results table. If a table contains many thousands of rows, it is recommended not to use this command unless the user desires to see all rows.

The fetch size of the Execute SQL Fetch All Rows command can be customized in the preferences menu (Edit -> Preferences). The fetch size simply determines how many rows will be returned from the database for each network call. By default RazorSQL uses the database driver settings for the fetch size.

Explain Plan

This command returns the explain plan for a given query. Explain plan is currently avabile for the following databases:

DB2, HSQLDB, MySQL, Oracle, PostgreSQL, SQL Server, and Sybase.

Execute All

This command executes all sql statements in the sql editor. This command requires each sql statement to be separated by a semi-colon (;). This command also requires the sql statements to be batchable statements, i.e., statements such as insert or update or delete.

Commit

This command sends a commit to the database. If auto-commit is turned on, a commit is automatically sent to the database after the execution of each sql statement. If auto-commit is turned off, the user is responsible for sending the commit call. Commit is only supported for databases that support transactions. If the database being used does not support transactions, it is recommended that auto-commit be turned on. Auto-commit is configured in the connection wizard process.

Rollback

This command sends a rollback to the database. This command is available only if auto-commit is turned off.