How To: Write SQL Queries with dbForge SQL Complete

dbForge SQL Complete can dramatically save your time whether you write a SQL query or format your code. This topic briefly explains how to write SQL queries using dbForge SQL Complete.

Writing a query

For example, you need to write a SQL query like SELECT * FROM Production.Culture.

  1. Open the Query Editor window and select the AdventureWorks database in the Available Databases list on the SQL Editor toolbar.
  2. Start typing: se (press Enter) * fr (press Enter)  

    When you are typing, the suggestion box appears with the list of suggestions that are relevant to the typed symbols. The suggestions are filtered to display most relevant ones at the top of the list. To insert a suggestion into your code, navigate to a required one by using Up and Down arrow keys, and press Enter.

    dbForge SQL Complete suggestion box

    Note: The first suggestion in the list is considered the most relevant, that is why it is highlighted to speed up the insertion.

  3. Press the Spacebar key and type cu (press Enter).

    Inserting a table name 

Formatting SQL code

dbForge SQL Complete can quickly format your SQL code based on the selected formatting options. To format your code, select SQL Complete>Format Document in the top menu.

To set up formatting rules, see Formatting Code topic.

See Also