Edit Structures Of Different Databases With Database Editor

Dealing with different types of databases and tired of switching between different RDBMS software to establish and check connections, execute queries, handle forms and tables, generate reports, etc? Perhaps, a database management solution capable of handling multiple databases would reduce the time and effort involved in managing different types of databases. You may find a handful of database viewers, having the ability to render a range of databases but what about editing and modifying structure of databases? Database Editor is a database explorer and editor which supports all database types of ODBC whilst supporting schemas of Oracle, DB2, SQL Server, MySQL, Access, SQLite, InterBase, etc.

Its major focus is on providing all the essential SQL editing tools with features to create, edit, execute queries. SQL history is also integrated within the application which lets user review previously modified and executed SQL queries. Moreover, you can choose to save most used SQL queries as templates which can be used anytime with other databases. This prevents you from writing somewhat same lines of commands in SQL editor to perform actions over tables. Just select the required template to import into current database.

For the first time, you have to create a couple of database connections, so you can switch between them with a single click. Unlike other Database managers, it doesn’t take too much time to establish and verify connection parameters. Connection can be created in 4 simple ways. You can either use installed providers, custom connection string, system DSN – ODBC connection, or user DSN ODBC connections.

The installed providers option presents all the installed DB servers and clients, letting you choose type of database from the list. By using selected DBMS OLE DB providers, it establish connection with your database within no time.

Connection's name  New

After the connection is established, it shows table hierarchy in main navigation bar while main MDI based window lets you to edit and execute SQL queries and view and modify database tables. SQL editor toolbar has options to save, print, edit, create new, and SQL execute commands. The pull-down menu lets you switch database connections quickly.

Database Editor - Table  Staff


To create a new table in current database, right-click on any table listed in main navigation bar and select Create Table. It presents an extensive database table creator with all the options to specify data type, unique identifier (primary key), default value, data size and so on.

create table 2

Apart from DB tables, it also allows you to create objects, such as, DB table view, tablespaces, trigger, function, schema, index, package, etc. You can for instance create a new function by specifying required parameters. It can generate SQL commands for your function, so you can use them in database and manipulate in a way you like.

tools

Database Editor certainly provides a complete database editing solution for database managers and administrators. Don’t forget to go through help guide which is available on the product page to understand all the features and functions it has to offer.

Download Database Editor

Advertisement
  • Gregg DesElms

    No matter how good the software, when its author doesn’t have the good sense to not use sub-standard and/or disreputable free hosting site like 110mb.com, then it makes one wonder how good could be the software. Sorry to be so critical, but the traffic from this article, alone, will likely be enough to use-up the web page’s entire bandwidth allocation for the month…

    …and since my clicking on the link just times-out (as of Sun 29 May 2011 @ 13:42 PDT), it seems I may (and I stress the word “may,” because I could be wrong) be right. The 110mb.com site is also well-known for not staying sufficiently on top of spammers, phishing sites, porn, and other problematic. There are several other FAR better choices for free web hosting.

    People who do freeware utilities for the greater good actually do a disservice to themselves, their product, and the public by taking too many shortcuts. Paid web hosting is sufficiently inexpensive these days that there’s almost no excuse, anymore, for using free web hosting, with all its rules, limits, lack of reliability, downtime, etc. Amortizing the cost across multiple products, and the utility’s author’s personal or professional site can easily make it worth the low cost. If this software author had made the decision to do that, then I’d be able to visit his site, read about his product, and download it. If he accepts donations, then I’d be able to make on of those, there, too.

    Just my opinion.