Are there any graphical tools for creating SQL code, developed to a degree that typing in the SQL commands is not required?
I have found one graphical IDE, but it is in alpha stage and actually does not work.
You didn’t mention which database servers you want to connect to…But I quite like Oracle’s SQL Developer. Its Java, lets you browse through tables, and connects to MySQL as well as Oracle - including the free version 10XE.
Creating tables, columns, indexes etc is done with point n click.
But for anything more than basic selects (using joins etc) you’ll still need to write some SQL.
I see; thank you.
I want to connect to Oracle and MySQL servers.