Difference between revisions of "SQL Browser"

Revision as of 20:19, 14 November 2011

Designer > Data > Objects > [SQL Browser]

The SQL Browser gives you a graphical interface that lets you enter a SQL query and view the results:

How it works

The navigation pane on the left shows all of the Object tables in your database.
Clicking the arrow next to one expands the tree, showing the columns in the table
Double-clicking a table populates the statement pane with a default query (SELECT *) from that table.
Clicking the triangle-button on the right runs the query.

Considerations

SQL syntax is not case-sensitive, except for table names and field names.
It's a good idea to enclose table names in back-ticks (`), in case the table name

turns out to be in the (fairly lengthly) list of SQL Reserved Words.

For example:

SELECT * FROM `ORDER`

(When you double-click a table name, the backticks are added for you.)

Learn more: SQL Syntax

@@ Line 14: / Line 14: @@
 ;Considerations:
 :* SQL syntax is not case-sensitive, except for table names and field names.
-:* It's a good idea to enclose table names in back-ticks (<tt>`</tt>), in case the table name turns out to be in the (fairly lengthly) list of [[SQL Reserved Words]].
+:* It's a good idea to enclose table names in back-ticks (<tt>`</tt>), in case the table name
+:: turns out to be in the (fairly lengthly) list of [[SQL Reserved Words]].
 :: For example:
 ::: <tt>SELECT * FROM `ORDER`</tt>