File dimension: 161 MB
RazorSQL is a unversal database query instrument, SQL editor, and database navigator. It includes a relational database engine that requires no configuration. Among the many main choices contained in RazorSQL are seen devices for creating, modifying, describing, altering, dropping, and viewing tables; devices for importing and exporting info; a database browser for the viewing of database objects and constructions; and a sturdy programming editor with help for SQL, PL/SQL, TransactSQL, SQL PL, Java, XML and loads of totally different programming languages.
Superior Connection Choices:
• Constructed-in help for DB2, Derby / JavaDB, Firebird, FrontBase, HSQLDB, Informix, MySQL, OpenBase, Oracle, PostgreSQL, SQLite, SQL Server, Sybase Adaptive Server Enterprise, and Sybase SQL Anyplace. Can even hook up with any database that helps JDBC or ODBC (Dwelling home windows solely) similar to Entry, Daffodil, H2, Ingres, Interbase, Mimer SQL, Mckoi, Paradox, Pervasive, Pointbase, Robust, and Teradata.
• MySQL, PostgreSQL, and MS SQL Server PHP bridges for connecting to MySQL, PostgreSQL, and SQL Server databases by PHP. Permits distant entry to MySQL, PostgreSQL or SQL Server databases /working behind PHP enabled web servers
• A MS SQL Server ASP bridge for connecting to SQL Server databases by ASP. Permits distant entry to SQL Server databases working behind ASP enabled web servers
• A RazorSQL JDBC Bridge for connecting to databases by a JEE/J2EE Software program Server or Servlet Container
Database and SQL Devices:
• Create, Alter, and Drop Tables and Views
• *Create and Drop Indexes and Sequences
• *Create and Drop Saved Procedures, Options, Packages, and Triggers
• *Create and Drop Databases and Prospects
• Edit Desk Software program
• *Edit Saved Procedures, Options, Packages, and Triggers
• Describe Tables and Views
• Generate DDL Software program for producing desk, view, and index DDL.
• View contents of Tables and Views
• *View contents of Saved Procedures, Options, Packages, and Triggers
• SQL Query Builder for Select, Insert, Exchange, and Delete Statements
• Export Info in textual content material, HTML, XML, Excel, delimited file format or as insert statements
• Import Info into tables from delimited info, Excel info, or mounted width info
• Execute Saved Procedures
• *SQL Make clear Plan Software program
• SQL Query Scheduler
• Look at Desk Info or Query Outcomes
• File Look at Software program
• Zip Utility for viewing/extracting Zip and Jar info
• File System Browser
• Database Meta Info Viewer (Options, Varieties, and so forth.)
• Command Line Interface for working RazorSQL devices from the command line.
SQL Editor:
• Syntax Highlighting for SQL, PL/SQL, TransactSQL, SQL PL, Batch, C, COBOL, CSS, C++, C#, Java, jаvascript, JSP, HTML, PHP, Perl, Python, Ruby, Shell Script, and XML
• Auto Completion for tables and columns
• Computerized Column Lookup
• Computerized Desk Lookup
• SQL Formatter
• Assist for parameterized queries
• Execute, Execute Fetch All, and Execute Batch options
• Multi-Tabular Present of Query Outcomes
• Sortable Query Outcomes
• Filterable Query Outcomes
• Searchable Query Outcomes
• SQL Historic previous for All Queries, and Query Logging Per Connection
• Auto-function lookup for all supported programming languages and auto-method lookup for Java and JSP
• Query Guidelines, Tag Guidelines, and Carry out / Method Guidelines selections for clickable present of queries, tags, or options / methods contained inside the editor
• File devices corresponding to go, tail, get half, search / regex search, switch, copy, rename, delete, dimension, and get info.
• Key Ahead efficiency for one-click inhabitants of user-defined textual content material
• Frequent Expression Uncover, Uncover/Change, Uncover/Change in Recordsdata
• Bracket Matching, Tag Matching, and Goto Line directions
• Printing Assist for Editor Content material materials and Query Outcomes
• Assist for dozens of file encodings
• Constructed-in and Custom-made Individual Templates
• Connection Maintain-Alive
• Plugin API (Permits prospects in order so as to add personalized efficiency to RazorSQL)
Database Browser:
• A tree development to navigate database objects
• Use RazorSQL provided database specific system queries or particular person geared up queries for database navigation, or navigate the database constructions using the default JDBC/ODBC driver settings.
• Single click on on content material materials viewing on tables, views, and so forth.
• Column information along with column title, keys, info form, nullable information, and so forth.
• *Exhibits information on objects similar to procedures, options, triggers, indexes, constraints, sequences, and so forth.
• Single-click period of DDL for tables, views, and indexes.
• Search tables and look at info.
• Single-click period of SQL select, insert, change, and delete queries.
Inbuilt Database:
• Requires no end-user configuration
• Get associated to a sturdy database correct out of the sphere
• Makes use of the extremely efficient HSQLDB database engine
Get hold of from 5Tbcloud.com