| |
Database Tools |
| |
Built-in Relational Database:
RazorSQL contains a built-in relational database. The database requires no
user configuration and can be launched right out of the box. To launch the built-in
database, select the Actions -> Connect to Built-in Database option.
Visual Table Tools:
RazorSQL contains tools for editing, creating, altering, describing and viewing tables.
These tools are located in the Tools menu. All of these tools give the option of seeing
the SQL automatically generated by RazorSQL before RazorSQL executes the SQL code.
Database Navigator:
RazorSQL contains a database navigator. The navigator can be customized by the
user using the "Configure Navigator" Actions menu option. By default, the navigator
uses the database driver to find out information about the database such as the
tables, functions, views, etc.
RazorSQL also provides custom database specific
navigator queries for certain major databases. These queries tend to provide
more information than the database driver.
RazorSQL also allows the database navigator to be customized by the user. The user
can enter custom queries for populating the navigator by accessing the "Configure Navigator"
Actions menu option.
Edit Table Tool:
RazorSQL contains an edit table tool that allows users to edit a table by clicking on
cells of a table and changing the text. RazorSQL then generates, insert, update, and/or
delete statements based on the changes made by the user.
Query Builder:
RazorSQL contains a query builder. The query builder can be accessed by selecting a table
from the navigator tree and either right-clicking and selecting query builder, or pressing
the query builder icon on the database navigator. The query builder can also be accessed
by pressing the query builder button on the sql editor and entering a table name.
The query builder contains four tabs: select, insert, update, and delete. After selecting
the specific information for the query, the user can select "generate sql" to preview the sql
that the query builder will execute. Selecting "execute sql" will execute the sql statement
on the current connection.
Import Wizard:
The import wizard allows users to import data from a delimited file. A delimited file is a file of
of values separated by a delimiter. For example:
1, 'John', 'Smith'
2, 'Jim', 'Jones'
The above is an example of comma-delimited data. Each row of data is contained on a line. The
import wizard can take that data and generate insert statements. The import wizard
then allows the user to execute the insert statements.
Export Wizard:
The export wizard allows users to export the results of a query into a delimited file,
HTML format, Text format, XLS format, XML format, or as SQL insert statements.
Call Procedure Tool:
The call procedure tool allows users to call stored procedures from RazorSQL. RazorSQL accepts IN,
OUT, and IN/OUT parameters. The call procedure tools displays the update count if the procedure updated
any table rows, and displays the data in any IN/OUT or OUT parameters as well as any data returned
as a ResultSet from the procedure.
Compare Tool:
The compare tools allows users to compare table data or query results or a mixture of the two.
Filter Query Results:
The filter query results option allows users to filter query results by selecting a column name and
entering a value. Only those results that match that value will be shown.
Sort Query Results:
The sort query results option allows users to sort query results by selecting a particular
column and then sorting in either ascending or descending order.
|
|