# RazorSQL

## Query, Edit, Browse, and Manage Databases

- razorsql.com
- Contact

# RazorSQL Feature Reference By Menu Grouping

Listed below are the names and descriptions for all features contained in RazorSQL grouped together by the menu in which the features are contained.
File Menu
Edit Menu
Search Menu
DB Tools Menu
Connections Menu
SQL Menu
Results Menu
Tools Menu
Code Menu
View Menu
Window Menu

## File Menu

New Tab (No Connection): Open a new tab containing a new database browser, SQL programming editor, and query results tabbed pane. The new tab will not be connected to a database until the Connections - Connect option is selected.
New Tab (Share Connection): Open a new tab containing a new database browser, SQL programming editor, and query results pane. The new tab will share the connection of whichever connection was selected from the sub-menu.
Open (No Connection): Open a file from the filesystem, and load that file's contents into the SQL programming editor. The syntax highlighting for the file will be set based on the file extension. The No Connection option means the tab will not be connected until the Connections - Connect option is selected.
Open (Share Connection): Open a file from the filesystem, and load that file's contents into the SQL programming editor. The syntax highlighting for the file will be set based on the file extension. The new tab will share the connection of whichever connection was selected from the sub-menu.
Under More Open Options . . .
Open URL: Opens the contents of a URL, for example, http://www.razorsql.com/ would return the page source for the RazorSQL site.
Open Choose Encoding: Opens a file with the file encoding selected from the sub-menu. Use this option if you do not want to open the file using the encoding selected in the Preferences, or if no encoding was selected in the preferences, the default operating system file encoding.
Open File Set: A file set can be created using the Create New File Set sub-menu option. A file set is a list of files to be opened simultaneously. Once a file set is created, the Open File Set sub-menu can be used to select the file set. Once the file set is created, a new tab will be created for each file in the file set.
Close: Closes the existing tab and closes any resources associated with the tab such as result sets, SQL statements, or database connections.
Under More Close Options . . .
Close All: Closes all tabs and closes any resources associated with the tabs such as result sets, SQL statements, or database connections.
Close All Except Current: Closes all tabs except the current tab and closes any resources associated with the tabs such as result sets, SQL statements, or database connections.
Save: Saves the contents of the SQL programming editor to the file system. If a file is already associated with the editor, the contents are saved to that file. If there is a no file associated with the editor, a dialog will appear prompting the user to select a file to save the contents to.
Save As: Saves the contents of the SQL programming editor to a file on the file system. A dialog will appear prompting the user to select which file to save the contents to.
Save All: Saves the contents of all of the currently open SQL editor tabs to the file system. If the tabs are associated with a file, the contents will be saved to those files. If not, a dialog will appear prompting the user to select a file to save the contents to.
Save Selection As: Saves the currently highlighted selection in the SQL editor to a file on the file system. A dialog will appear prompting the user to select a file to save the contents to.
Save Choose Encoding: Saves the contents of the currently selected SQL editor to the file system using the character encoding choosen from the sub-menu.
Templates: The templates menu item contains a sub-menu that contains templates for the programming languages supported by RazorSQL such as PL/SQL, SQL, Transact SQL, SQL PL, Java, XML, HTML, CSS, JavaScript, PHP, etc. Users can add their own templates to the Templates menu by selecting the Add Template option from the submenu.
Recent Files: This menu contains a sub-menu listing all of the recent files that were opened by RazorSQL. Clicking on one of the files listed opens a new tab with that files contents in the SQL programming editor.
Recent Directories: This menu contains a sub-menu listing all of the recent directories that were the parents of files opened by RazorSQL. Clicking on one of the directories brings up a dialog with the contents of that directory, and allows the user to select one of the files in the directory for opening.
Current Directory: This menu contains the files contained in the parent directory of the file that is associated with the currently active tab in RazorSQL. If there is no file associated with the currently active tab, there are no items displayed.
Favorites: The favorites item allows users to bookmark files or directories so that they can be quickly opened at a later time. To add a file or directory to the favorites, simply open the file, and select either Add Current File to Favorites or Add Current Directory to Favorites.
Tools: The File - Tools menu contains the following file tools:
Size: Displays the size of the selected file in megabytes, kilobytes, and bytes.
Get Info: Displays information about the selected file such as its modification date, type, and size.
Search: Performs a normal or regular expression search on the selected file and displays the results as the contents of a new SQL editor tab.
Head: Performs a head on the selected file by retrieving the first so many lines of the file as specfied by the user. The results are displayed as the contents of a new SQL editor tab.
Get Section: Gets the contents of the selected file from the begin and end lines specified by the user. The results are displayed as the contents of a new SQL editor tab.
Tail: Performs a tail on the selected file by retrieving the last so many lines of the file as specified by the user. The results are displayed as the contents of a new SQL editor tab.
Rename: Renames the selected file to the new name specified by the user.
Move: Moves the selected file to a new location as specified by the user.
Delete: Deletes the selected file.
Conversions: The File - Conversions menu contains options for converting the file's line breaks either to Windows line breaks (carriage return line feed), Unix line breaks (line feed) or Mac Classic line breaks (carriage return).
Show in Web Browser: Shows the currently active contents of the SQL programming editor as an HTML page in the default web browser for the user's system.
Backup Editor File: Makes a backup of the file in the currently active tab.
Compare Files: Allows the user to select two files to compare and then displays the differences of the compared files. This is similar to the UNIX diff command.
Reload: Reloads the contents of the currently active SQL editor if there is a file associated with that editor.
Reload All: Reloads the contents of the SQL editors for all tabs if there are files assoicated with those editors.
Reload Choose Encoding: If the currently active SQL editor has a file associated with it, reloads the editor using the character encoding chosen by the user.
Print: Allows the user to either print the SQL editor contents or the results of the currenly active query results tab.

## Edit Menu

Undo: Undoes the last operation performed in the editor. Undo can be re-selected hundreds of times to undo operations in the sequence that they were performed.
Redo: Redoes the last operation performed in the editor. Redo can be re-selected hundreds of times to redo operations in the sequence that they were performed.
Cut: Cuts the highlighted text from the SQL programming editor and places it on the system clipboard.
Copy: Copies the highlighted text from either the SQL programming editor or query results and places it on the system clipboard.
Paste: Pastes the contents of the system clipboard to the SQL programming editor.
Select All: Selects all the text in either the SQL programming editor or in the query results.
Sticky Cut: Cuts the highlighted text from the SQL programming editor and stores it indefinitely in a special clipboard provided by RazorSQL.
Sticky Copy: Copies the highlighted text from either the SQL programming editor or query results and places it indefinitely in a special clipboard provided by RazorSQL.
Sticky Paste: Pastes the contents of the RazorSQL sticky clipboard to the SQL editor.
Delete Menu: Contains many operations for deleting text such as the following: Delete Word, Backspace Word, Delete Line, Delete to Start of Line, Delete to End of Line.
Select Menu: Contains many operations for selecting text such as selecting lines, paragraphs, pages, characters, and words.
Text Menu: Contains text operations such as upper casing or lower casing text, appending and prepending text to lines, removing trailing and beginning white space, removing blank lines, removing duplicate lines, sorting lines, word counts, formatting to fit screen, wrapping text at a column number, and unwrapping text.
Shift Selection Left: Shifts the highlighted selection in the SQL editor to the left by one tab.
Shift Selection Right: Shifts the highlighted selection in the SQL editor to the right by one tab.
Previous Word: Moves the cursor in the SQL programming editor to the beginning of the previous word.
Next Word: Moves the cursor in the SQL programming editor to the beginning of the next word.
Previous Paragraph: Moves the cursor in the SQL programming editor to the beginning of the paragraph.
Next Paragraph: Moves the cursor in the SQL programming editor to the beginning of the next paragraph.
Document Begin: Moves the cursor in the SQL editor to the beginning of the document.
Document End: Moves the cursor in the SQL editor to the end of the document.
Date Time: Print the current date and time in the currently active SQL editor.
Preferences: Displays the Preferences window where users can edit preferences.

## Search Menu

Database Data Search: The database data search tool is a tool that allows users to search single or multiple tables. The user chooses which columns to use in the search criteria, and what kind of data to look for in those columns. Once the criteria is entered, the search generates database queries behind the scenes and displays the results.
Database Object Search: The database object search tool allows users to find database objects such as tables, views, procedures, triggers, indexes, etc. Types of objects available for searching are dependent on the type of database that is connected to. The results of the object search are displayed in tree view. Right-clicking on the nodes in the tree provides a menu with options.
Find / Replace: Displays the Find / Replace dialog. This dialog allows users to find text in the currently active SQL programming editor with options such as forward and backward direction, all lines or selected lines only, case sensitivity, whole word only search, wrap search, show found lines, and count all.
Users can also replace found text using the Replace, Replace / Find, and Replace All buttons.
Find Next: Finds the next search text in the SQL editor. If there is text selected, Find Next looks for text matching the selection. If not, Find Next tries to get the last Find done for the current session and looks for that text.
Find Previous: Finds the previous search text in the SQL editor. If there is text selected, Find Previous looks for text matching the selection. If not, Find Previous tries to get the last Find done for the current session and looks for that text.
Find Selection: Searches for text in the SQL editor using the current selection as the search parameter.
Replace Range: Replaces a range of text in the SQL editor, from beginning column number to ending column number, with text specified by the user. Replace Range can work on all lines or only the selected lines.
Goto Line: Places the SQL editor cursor at the beginning of the line number as specified by the user.
Match Bracket: Highlights text in the SQL editor from the first bracket after the cursor to the ending bracket for the beginning bracket. Brackets can include parentheses, curly brackets, and braces.
Match Tag: Highlights text in the SQL editor from the first tag after the cursor to the ending tabg for the beginning tag.
Find / Replace In Files: Searches for text in files on the file system. If the find button is pressed, this text is displayed in a window with clickable icons to take the user to the exact line of text in the file where the text was found. Users can specify the file type to search in, and the directory to start the search. There is a match case option, and the ability to search sub directories.
If the Replace All button is pressed, all found text is replaced with the text in the Replace With box.
Find in Open Editors: Search for text in the RazorSQL SQL editor tabs. Found text is displayed in a window with clickable links to take the user to the exact line of the found text in the appropriate tab.
Bookmarks: The bookmark options allow users to add bookmarks to lines in the SQL editor. Users can then "jump" to those bookmarks using the next and previous bookmark menu options or keyboard shortcuts.

## DB Tools Menu

Create Menu: The Create menu includes options for creating database objects such as tables, views, indexes, sequences, packages, package bodies, procedures, functions, triggers, databases, and users. Not all options are available for all database types.
The Create tools prompt users for information on the database object such as the object name, attributes, etc., and then generate and execute the SQL to create the database objects. All SQL can be previewed before being executed by RazorSQL.
Alter Menu: The Alter menu includes options for altering database objects such as tables and views. The Alter Table option includes options such as adding primary keys, foreign keys, and check constraints, dropping columns and constraints, and renaming tables and columns. Not all Alter options are available for all database types.
The Alter tools generate and then execute the SQL to alter the database object. All SQL can be previewed before being executed by RazorSQL.
Drop Menu: The Drop menu includes options for dropping database objects such as tables, views, indexes, sequences, packages, package bodies, procedures, functions, triggers, databases, and users. Not all options are available for all database types.
The Drop tools generate and then execute the SQL to drop the database object. All SQL can be previewed before being executed by RazorSQL.
Edit Menu: The Edit menu includes options for editing tables, packages, package bodies, procedures, functions, and triggers.
The Edit Table option brings up the contents of the table in a spreadsheet like format and allows the user to modify the values in the cells. The Edit Table tool can then generate and/or execute the SQL for any changes made by the user. The Edit Table Tool also has options such as a find tool to find data in the table, and the ability to enter text in a separate window outside of the cell that is useful when editing large blocks of text. The Edit Table Tool also allows users to insert and delete rows.
The other edit options for packages, package bodies, procedures, functions, and triggers, populate the currently active SQL programming editor with the contents of the database object to allow users to edit them.
View Menu: The View menu includes options for viewing table contents, and also viewing the contents of packages, package bodies, procedures, functions, and triggers.
Describe: The describe option is used to describe a table or view and includes such information as column name, column type, column size, primary key status, foreign key status, nullability, and scale.
Table Relationships: The table relationship options allows a user to select a table and then displays all foreign key relationships to that table.
Execute SQL Script: The execute SQL script option executes the contents of an SQL file. The user needs to provide the SQL statement separator used by the file if the file has multiple statements. Note that queries that return results are not supported by the execute sql script option.
Import Data: The Import tool allows users to import data into tables from Excel files, delimited files, SQL files, or fixed width files.
Export Data: The Export tool allows users to export data from tables, views, or queries in several formats including Excel, delimited format, HTML, XML, Text, JSON and as SQL insert statements. Multiple or single tables can be exported at a time.
Copy Table: The copy table option allows a user to select an existing table from the database and copy it to a new table.
Copy Table to Another Database: This option allows the user to copy a table from the current database to another database of the same type. This option can either generate an SQL file containing the statements to copy the table or execute the copy table statements directly on the remote database.
Copy to Local Database: This option allows users to copy a table from the current database to RazorSQL's built-in database. There are sub-menu options for copying one table or multiple tables to RazorSQL's database.
Backup: RazorSQL supports backup options for certain databases. There are sub-menu options for backing up a single table, or for backing up a database / schema. When backing up a database or schema, the types of objects that are supported for backup are dependent on the database type. Examples include tables, views, indexes, functions, procedures, and triggers. The backup options generate an SQL file containing DDL and SQL insert statements for the objects and data contained in the table or database / schema.
Database Conversion: RazorSQL supports database conversion for certain databases. Users can convert a single table or multiple tables in a schema or database. The database conversion tool can generate an SQL script file containing the DDL and SQL insert statements for the converted tables, or it can execute the DDL and SQL directly on another connection, or it can do both.
Generate DDL: This option allows users to generate the database definition language (DDL) for various database objects such as tables, views, indexes, procedures, etc.
Auto Complete: The auto complete option will automatically complete started text in the SQL editor. The auto complete option displays a list of tables and views that start with the text entered into the editor.
Column Lookup: The column lookup option prompts the user for a table or view and then displays the columns of the table or view in a popup list in the currently active SQL editor. This allows the user to quickly select a column from a table or view without having to type the column name. The SQL editor also has auto column lookup that will automatically display the list of columns for a table.
Table Lookup: The table lookup option prompts the user for a database and/or schema and then displays the tables and views located in that database and/or schema. This allows the user to quickly select a table or view without having to type the name. The SQL editor also has auto table lookup that will automatically display the list of tables for a database or schema.
Execute Procedure / Function: The execute procedure option prompts users for values to each of the input parameters of a procedure or function, and then calls that procedure or function and returns the output.
Query Builder: The Query Builder Tool allows users to visually build select, insert, update, or delete SQL statements against tables.
The Query Builder Tool allows the user to select the columns to be used in the SQL statement as well as the SQL operations to be included in the query. It also allows for the selection of aggregate functions and group by clauses and allows for selection of multiple tables for join selects. After selecting the appropriate options and entering any custom values, the Query Builder Tool can generate and/or execute the SQL corresponding to the selections.
Compare Tool: The compare tool allows users to compare either tables and views or query results. The compare process then generates and displays a report of the differences between the objects that were compared.
Query Scheduler: The Query Scheduler tool allows users to schedule SQL queries based on a time interval and number of executions and have the results of the query written to an output file.
Command Line Call Generator: RazorSQL has a command line interface that allows users to perform operations outside of the RazorSQL GUI from the command line or terminal. The command line call generator tool guides the user through generating a command that can be executed outside of RazorSQL. Commands include the following:
Backup Database (if RazorSQL supports backup for the database type)
Backup Table (if RazorSQL supports backup for the database type)
Execute SQL Script
Export Table / Query Data
Import Table Data
Compare Query Results
Convert Table (if RazorSQL supports conversion for the database type)

## Connections Menu

New Tab (No Connection): Creates a new tab that is not connected to a database.
New Tab (Share Connection): Creates a new tab that shares its connection with the connection selected by the user.
Connect: Brings up a list of currently configured connection profiles. The user can then select a profile and connect to a database. If no profiles have been configured, the Connect option brings up the Connection Wizard that allows users to create connection profiles.
Add Connection Profile: Brings up the connection wizard tool. This is used to configure and create a database connection. The information used to connect is then saved in a connection profile that can be accessed for future use via the Connect option.
Disconnect: Disconnects and closes all resources associated to the connection that is associated with the currently active tab.
Disconnect All: Disconnect All closes all currently open connections and closes all resources associated with those connections.
Connect to Built in Database (HSLQDB): Connects to the database that ships with RazorSQL, the HSQLDB database.
View SQL History: Displays the contents of the SQL History. SQL History contains the last 20,000 lines of SQL executed in RazorSQL. The number of lines of history stored can be configured in the Preferences tool.
View Query Log: The query log holds all queries executed on the current RazorSQL tab.
View Meta Data: Displays a window containing meta data information about the database such as version information, driver information, keywords, built-in functions, types, etc.
View DBMS Output: For Oracle database connections, if users set the View DBMS Output option to on via the toolbar dropdown, the View DBMS Output menu option becomes active. RazorSQL then checks for DBMS output for any statement executed. If there is DBMS output available, clicking on the View DBMS output option will display the output.
View Print Output: For SQL Server, PostgreSQL, and Sybase databases, if an SQL statement contains print output, the View Print Output option will display the Print output of the last executed statement.
Configure Navigator: The configure navigator option gives users the ability to configure the database navigator. For some databases, the System Navigator option is available. This option generally generates the most information about database objects and is enabled by default where applicable. The Driver option gets all of the database information from the driver. Since the driver only returns information on tables, views, and procedures, this option does not contain as much information as the System Navigator. The Custom Navigator option enables users to enter their own queries for querying the database and displaying that information in the navigator.
Filter Navigator: If users do not want certain objects to display in the database navigator, they can choose the filter navigator option to filter what gets displayed.
Reload Navigator: Reloads and refreshes the database navigator with any changes that may have occurred since the last refresh.

## SQL Menu

Execute SQL (One Statement): The execute option determines which statement from the query editor to execute based on certain conditions. If an SQL statement is highlighted in the query editor, that statement will be executed. If there are no statements highlighted, and the language type is set to SQL, PL/SQL, TSQL, or SQL PL, RazorSQL will then check for statement separators (by default the semi-colon). If there are statements separated by statement separators, RazorSQL will execute the closest statement based on the cursor position. If there are no statement separators, or if the language type is something other than one of the SQL variants such as HTML, RazorSQL will attempt to execute the entire contents of the query editor. For PL/SQL and SQL PL, RazorSQL will not parse queries based on statement separators if the statement separator is the semi-colon if it determines there are blocks of code, such as begin, end blocks in the editor.
The execute process executes the sql statement. If the statement performs an insert, update, or delete, RazorSQL will attempt to display the number of rows affected in the SQL status panel.
If the query is a select, RazorSQL will display the results of the query in the query results section. RazorSQL determines how many rows to fetch of the query by looking at the fetch size preferences first, and if nothing is specified, by using the specific database driver settings. Most drivers by default have a fetch size of around 100 rows. If the user attempts to scroll to see more than the number of rows fetched, RazorSQL will then try to fetch the next set of rows from the database. The SQL status panel will be updated each time RazorSQL calls back to the database driver to fetch more rows.
Certain database tools only perform actions on the fetched rows. For example, the sort and filter query results option only sort or filter the rows displayed in the query results. If the user wishes to sort or filter the entire contents of the query, the user should use the "execute fetch all rows" option. However, this option should not be used if there are a large number of rows expected to be returned from a query, as very large numbers of rows can cause performance problems.
Execute SQL - Fetch All Rows: The Execute SQL Fetch All Rows option works exactly like the Execute SQL option for all queries except those that return results, such as select queries. For queries that return results, the fetch all rows option makes sure to fetch all rows from the database and display all of those rows in the query results tab, as opposed to only fetching a set number of rows and not doing another fetch until the user scrolls down to see unfectched rows.
Care should be used when using the fetch all rows options for queries that are expected to return very large result sets. Very large result sets could consume enough memory and generate enough network traffic to cause performance problems.
Execute SQL (All Statements): The Execute All option executes all SQL statements in the query editor.
The Execute All option requires the SQL statements to be separated by statement separators, by default, semi-colons (;).
The execute all option executes each statement one by one. By default, if there is an error, execution will stop. This behavior can be changed in the preferences.
Execute SQL (All Statements - Fetch All Rows): This option behaves exactly like the Execute SQL (All Statements) option except that all rows from each statement (assuming the statement returns results) are fetched. Care should be used with this option if any of the queries return a very large number of rows.
Execute SQL (All Statements Close Current Tabs): This option closes are existing query results tabs prior to executing the statements.
Execute SQL (One Statement) - Output to File: This option executes either the currently highlighted statement or statement nearest the current cursor position. It then generates a delimited file containing the results of the statement. A window appears prior to execution that allows the user to specify the delimiter to use.
Execute SQL (All Statements) - Output to File: This option behaves exactly like Execute SQL (One Statement) - Output to File except that it executes all statements in the current editor.
Explain Plan: The Explain Plan option generates an explain plan for a query. To generate an explain plan, either highlight a query, or if nothing is highlighted and the language type is SQL mode, separate the queries in the editor by semi-colons and position the cursor within the query to explain, or if there are no semi-colons or highlighted queries, RazorSQL will send the entire contents of the editor to be explained.
The Explain Plan option is currently available for the following databases:
DB2
HSQLDB
MySQL
Oracle
PostgreSQL
SQLite
SQL Server
Sybase
Commit: When a connection is setup with the auto-commit mode set to off, the SQL Commit and Rollback options become available.
Use the commit option to commit a transaction or statement of work to the database.
Please note that some database do not support transactions, such as older versions of MySQL. In these cases, the commit and rollback options become meaningless. Also, some databases handle transactions differently than others. For example, PostgreSQL handles transactions differently than the other major databases such as Oracle or SQL Server. RazorSQL attempts to handle this by issuing SavePoints when using PostgreSQL in auto-commit off mode so that transactions do not get into an invalid state.
Rollback: When a connection is setup with the auto-commit mode set to off, the SQL Commit and Rollback options become available.
Use the rollback option to rollback any work since the last commit.
Please note that some database do not support transactions, such as older versions of MySQL. In these cases, the commit and rollback options become meaningless. Also, some databases handle transactions differently than others. For example, PostgreSQL handles transactions differently than the other major databases such as Oracle or SQL Server. RazorSQL attempts to handle this by issuing SavePoints when using PostgreSQL in auto-commit off mode so that transactions do not get into an invalid state.
Clear Saved Query Parameters: This option clears any parameters that had been set by the user for the current session. Parameters can be set by using ampersands (&) in queries. When RazorSQL detects an ampersand in a query, it will prompt the user for a value to substitute for the ampersand. To clear values that were set at the session level, select the clear saved query parameters menu option.
Format SQL: RazorSQL includes an SQL Formatter tool that can be used to insert line breaks in user-customized areas such as before and/or after commas, SQL keywords, brackets, AND/OR, etc. It also allows users to specify text formatting such as text wrapping, upper-casing, and indenting.
SQL Parser: The SQL Parser option allows a user to parse an SQL statement to check for errors. The SQL parser used is a generic parser that is not database specific. Because of this, custom database syntax may not be supported by the parser.
Favorites: RazorSQL includes an SQL Favorites menu option that allows users to add and remove SQL queries or statements to a favorites list. Selecting a query from the favorites list will insert the query into the beginning of the editor. Users can select favorites either by using the SQL Favorites menu or by using the Favorites Selector tool. The selector tool displays a window listing all of the favorites, and allows users to select a query to insert into the editor.

## Results Menu

Filter Query Results: Allows the user to filter the displayed query results by specifying criteria for what data should be displayed.
Sort Query Results: Allows the user to sort the query results by whatever column they choose.
Copy Results to Clipboard Copies the results and column names in the currently active results tab to the system clipboard.
Generate SQL Select for Selected Cells: This option uses the cells selected in the query results, and generates SQL select statements using the columns and values for these cells.
Generate SQL Update for Selected Cells: This option uses the cells selected in the query results, and generates SQL update statements using the columns and values for these cells.
Generate SQL Insert for Selected Rows: This option generates SQL insert statements using any rows in the query results that have selected cells.
Generate SQL Delete for Selected Rows: This options generates SQL delete statements using any rows in the query results that have selected cells. If the table that the delete is being generated for has primary keys defined, those keys are used in the where clause of the delete statement. If not, all columns are used to generate the delete where clause.
Re-execute Query: This option re-executes the query behind the current active results tab. The current active tab is overwritten by the re-executed query results.
Edit Cells: This option turns on the results data cell editor. If there are no currently selected cells, the first cell is enabled for editing.
Save / View Cell Edits: If the cell editor was turned on and changes were made, select this option to preview and/or execute the cell changes.
Fetch All Results: This option fetches all remaining rows (if applicable) for the currently active query results tab.
Create Table from Results: This option allows the user to create a new table using the columns and values in the currently active query results tab. There are options for creating the new table on the current active database connection, on RazorSQL's local database, or on another database if the database type is supported by RazorSQL's database conversion tool.

## Tools Menu

FTP / SFTP Client: RazorSQL includes an FTP and SFTP client for connecting to servers via FTP or using secure FTP over SSH. Selecting the FTP / SFTP Client option will display a window with any currently configured FTP / SFTP connections and also provide the ability for the user to manage existing connections or create new connections.
Plugins Menu: This menu contains any plugins defined in RazorSQL. See the Plugin Guide for information on how to write plugins - Plugin Guide
Macros Menu: The macros menu has options for users to record keyboard macros, and once the macro has been recorded, options to select the macro for execution. Once there have been macros recorded, users can use the Macro Selector shortcut to display a list of available macros for execution.
When recording is started, any characters typed into the SQL editor or any keyboard shortcuts invoked from within the SQL editor get recorded. Anything done outside of the editor does not get recorded.
International Editor: The international editor displays an input box in the SQL editor that allows users to type international characters. This would mainly be for users that need to type specific keyboard combinations to type an international character.
Key Ahead: The programming editor provides key ahead functionality that can be invoked by using the control/command K keyboard combination or the Tools - Key Ahead menu option.
Key Ahead displays a selectable list of items based on the current language type of the editor. The editor has pre-configured many key ahead items. The user is also able to add items to the key ahead list for languages by selecting the Key Ahead tab of the preferences window.
Zip Utility: The Zip utility allows users to view and extract the contents of Zip or Jar files.
Execute Shell Script / Batch: The execute script option allows users to execute shell or batch scripts located on their machine. The output of the script is then displayed to the user.
Execute OS Command (Non-Windows): The execute OS command allows users to execute operating system commands via EditRocket. This is similar to opening a terminal appication or command prompt.
ASCII Table: The ASCII table option displays an ASCII table with information in decimal, octal, hex, and binary format.
Color Chooser: The Color Chooser allows users to choose colors in HTML Hex or RGB format from a color wheel or by color name.
Set Local Web Server Properties: Set the local web server properties for various programming languages. RazorSQL will then use this information when launching a web browser via the "Show in Web Browser" option.
Programming Language Sub-menus: These are menus containing tools for various programming languages such as PHP, Java, HTML, XML, CSS, etc.

## Code Menu

Sidekicks Menu: This contains the sidekicks for the various programmign languages supported by RazorSQL such as PL/SQL, Java, PHP, XML, etc.
Inserts Menu: This menu contains code inserts for the various programming languages supported by RazorSQL.
Utils Menu: The utils menu contains langauge utils for languages such as C, HTML, Java, and XML, and includes such options as encoding and decoding URLs, converting selections to hyperlinks, etc.
Builders Menu: EditRocket provides Code Builders for many programming languages such as C, Java, JavaScript, Perl, PHP, PL/SQL, Python, Ruby, Shell Script, and Transact-SQL. Code Builders allow users to easily create code by selecting options from the code builder window. For example, the PHP Code Builder has information such as function signatures, function descriptions, and version information on all functions available in PHP. The Code Builder lets users easily select one of these functions and insert it into the editor. Function Lookup: The editor provides function lookup for the various languages it supports. Function lookup can be used via the function lookup icon, the control/command L keyboard combination, or the Tools - Function Lookup menu option.
The function lookup works by determining a list of functions based on the current language type in the editor and then displaying them in a selectable list. For example, SQL function lookup would display the SQL aggregate functions. PL/SQL function lookup would display all of the PL/SQL functions like UPPER, DBMS_OUTPUT, etc. The Java function lookup would display methods pertaining to the class type of the variable on which the user is doing the lookup.
Function / Method Navigator: The function / method navigator tool displays a list of functions contained in the currently active editor. The functions are determined based on language type. For example, if the language type is JavaScript, JavaScript functions will be displayed. The functions displayed have a clickable icon so that users can be taken directly to the position in the editor where the function is located.
Query Navigator: The query navigator tool displays a list of SQL queries contained in the currently active editor. The queries displayed have a clickable icon so that users can be taken directly to the position in the editor where the query is located.
Tag Navigator: The tag navigator tool displays a list of tags contained in the currently active editor. The tags displayed have a clickable icon so that users can be taken directly to the position in the editor where the tag is located. The tag list is useful when the language type for the editor is HTML or XML.
Function / Method Selector: This option allows users to quickly jump to funtions or method by using the keyboard shortcut for the selector, or by selecting the menu option.
Range Comment: This option inserts a range comment into the editor, or if there is selected text, wraps the selected text in a range comment.
Line Comment: This option inserts a line comment into the editor, or if there is selected text, wraps each line in a line comment.

## View Menu

Customize Toolbar: Allows users to customize which icons appear on the toolbar.
Font: Allows users to customize the font for the SQL editor, database navigator, and query results.
Increase Editor Font: Increases the editor font by one size.
Decrease Editor Font: Decreases the editor font by one size.
Programming Language: Allows the user to select the programming language to use for the syntax highlighting and tools such as function lookup for the current editor. Options includes SQL, PL/SQL, TSQL, SQL PL, Batch, C, C++, C#, COBOL, CSS, HTML, Java, JavaScript, JSP, PHP, Perl, Python, Ruby, Shell Script, and XML.
Show Default View: Shows the default RazorSQL view, which includes the database navigator, SQL editor, query results, and status pane.
Show Editor Only: Hides all panes except for the editor.
Query / Programming Editor: Show / Hide the SQL editor.
Query Results: Show / Hide the query results.
Database Navigator: Show / Hide the database navigator.
Status Panel: Show / Hide the status panel.
File System Browser: Show / Hide the file system browser.

## Window Menu

Close All Tabs: Close all connections, resources, and hide all tabs.
Close All Except Current: Close all connections and resources, and all tabs except the current tab.
Close All Query Results: Close all SQL statement and result set resources and close all query results for the current active tab.
Close All Results Except Current: Close all SQL statement and result set resources and close all query results except for the current query results for the current active tab.
Next Tab: Make the next RazorSQL tab active.
Previous Tab: Make the previous RazorSQL tab active.