In case you want to run one SQL query at a time, you can choose the ‘Execute SQL (One Statement)’ option, otherwise you can access the other features such as ‘Execute SQL Fetch All Rows’ or Execute SQL. Besides, if you want to import data from delimited files, Excel spreadsheets, fixed width files into the current database, you can use the proper option from the main toolbar.
The main window enables you to execute as many SQL scripts as you want, while the Console section retrieves all the necessary data. Once the connection is established, the left panel displays all of the identified data, thus allowing you to edit it the way you want. Once it is created, it can be used to connect to whatever database you want. Irrespective of the database you choose to work with, be it Oracle, MS SQL Server, MySQL, PostgreSQL, Firebird, Interbase, Apache Derby, Salesforce, SQL Azure, SQLite, MongoDB, Frontbase or JavaDB, the application helps you to edit SQL scripts, gather information from multiple tables, create indexes and views.īecause it stores connection information in ‘connection profiles’, you need to make a new profile. Working with different databases and executing SQL scripts ranging from simple SELECT statements to complex procedures, RazorSQL proves to be an intuitive and steady solution especially designed for database administrators who need to create, alter, describe, execute and drop database objects such as tables, views, indexes, stored procedures and functions.
An intuitive and straightforward SQL database query tool, browser and editor that supports all major databases such as MySQL, Oracle, SQL Server or Sysbase, to name a few.
0 kommentar(er)
