Difference between revisions of "SQL Browser"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
Line 19: Line 19:
:: (When you double-click a table name, the backticks are added for you.)
:: (When you double-click a table name, the backticks are added for you.)


;Learn more:
''Learn more:'' [[SQL Syntax]]
:* [[SQL Syntax]]
:* [[SQL Functions]]

Revision as of 20:16, 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:

SQLBrowserSelect.png
How it works
  • The navigation pane on the left shows all of the 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.
SQLBrowserGoButton.png
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