Ben Chuanlong Du's Blog

It is never too late to learn.

IDE for SQL

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

dbeaver

The best universal IDE for (almost all versions of) database.

DataGrip

DataGrip (from JetBrains) looks like a good one

DbVisualizer

Both free and pro editions are available. Functionalities of the free is too limited. It is suggested that you use dbeaver if you prefer a free SQL IDE.

ApexSQL

ApexSQL is a nice and free SQL formatting tool for VisualStudio SQL Server.

Teradata Studio

  1. How to change the default workspace in Teradata Studio?

Oracle SQL Developer

A free IDE for Oracle SQL.

  1. By default, Oracle SQL Developer runs all queries in the current editor. The ending semicolon (;) matters when you develop SQL in Oracel SQL Developer, which is different from most other SQL IDEs. If you want to run a specific query in the current editor, you have to select it first and then run it (by clicking the Run button or using hotkeys).

  2. how to show line numbers in oracle sql developer?

  3. how to change language to English?

Teradata SQL Assistant

Comments