Figure 0.1 SQL Builder
The SQL Builder is a tool to help you create and maintain SQL statements. Use a point and click approach to build any SQL statement you want. The objects are inserted into the SQL statement text at the current location of the cursor.
Click on the desired SQL keywords, and columns to add them to the SQL statement. Click on a table to view it's list of columns. Double click on a table to add the table name to the SQL statement.
If you have set up a target database connection the SQL statements may be executed by pressing the Run push button. Click on the Result tab to see the results.
SQL statements may be saved to file, and opened at a later point in time to resume editing, or to execute them again.
Warning: TurboData will not validate your syntax in the SQL Builder. Your DBMS will soon let you know if there are any errors in the syntax!
