Context-based prompts for SQL database objects and statements

dbForge Studio for SQL Server provides smart prompts for database objects and SQL statements and auto-completes the current code.

Prompts Overview

Context-based prompt of different object types

When you type a query, dbForge Studio for SQL Server displays names of all valid databases. It also displays objects from the specified database or schema, or column names from the specified table. Object types have different icons, so you can easily recognize them. The complete list of the supported types is available in the Prompt List Supported Types topic.

Context-based prompt of keywords

dbForge Studio for SQL Server provides a list of expected keywords to use in the current position of your code. For example, if you type SELECT *, the list shows all available keywords that match the context.

Context-based prompt of keywords

Context-based prompt of linked servers

dbForge Studio for SQL Server displays names of the following linked servers:

  • SQL Server 2000
  • SQL Server 2005
  • SQL Server 2008
  • SQL Server 2012
  • SQL Server 2014
  • SQL Azure

Context-based prompt of linked servers

Context-based prompt of function parameters

When calling any built-in or user-defined function in a query, a hint with information about the function and parameters it requires appears.

Context-based prompt of function parameters

Context-based prompt for JOIN clause

For JOIN clauses, dbForge Studio for SQL Server can suggest a full JOIN clause that is based on foreign keys, or conditions that are based on column names and foreign keys. This suggestion is available after JOIN and ON keywords.

Determining a current database or schema

dbForge Studio for SQL Server displays a list of database objects from a current database or schema even when their names are not specified in a query. Also, the tool finds USE statements in code and changes the current database for subsequent SQL statements.

Determining a current database or schema

Code completion in SQLCMD mode

This feature ensures that values of variables are taken out from the document and object suggestions work as with an ordinary SQL script when scripts are executed with the help of the command line utility.

Column picker for quick list building

This feature allows defining column lists for selecting, grouping, sorting and inserting without typing any code at all.

Note

* These features are available in the Standard edition of dbForge Studio for SQL Server only.

** The Express edition of dbForge Studio for SQL Server offers partial support of these features. Full support is available in the Standard edition only.

Refresh Local Cache

If you are writing a query against a database while someone else is making changes to its structure, the suggestions offered by dbForge dbForge Studio for SQL Server may become out of date. For instance, if someone added several tables to a database while you were connected to that database, the tables will not appear in the suggestions box. To reload the database objects, click Refresh Local Cache on the Text toolbar. Refreshing suggestions applies only to the database to which you are currently connected.

Reset Suggestions Cache

If you connect to a number of different databases during the same session, dbForge dbForge Studio for SQL Server will load all the objects for each database as required, without unloading any of the previously stored objects. This means that you can go back to previous queries and continue to see suggestions for any database to which you were connected previously.

dbForge dbForge Studio for SQL Server loads database objects into its memory whenever you connect to a database, in order to display suggestions from that database. If you connect to several databases with a large number of objects, this may eventually result in running out of memory. To reset the memory at any time, click Reset Suggestion Cache on the Text toolbar.

Prompt List Supported Types

Below is the list of objects that are supported by the prompt list of dbForge Studio.

Databases Databases

Linked Servers Linked Servers

Schemas Schemas

Tables Tables

Views Views

Encrypted Views Encrypted Views

Columns of table objects Columns of table objects

Scalar functions Scalar functions (including CLR), CLR aggregate functions

Table-valued (including CLR) functions Table-valued (including CLR) functions

Built-in functions Built-in functions

Table level trigger Table level trigger

Encrypted table level trigger Encrypted table level trigger

Database level trigger Database level trigger

Encrypted database level trigger Encrypted database level trigger

Server level trigger Server level trigger

Encrypted server level trigger Encrypted server level trigger

Sequences Sequences

Synonyms for supported objects Synonyms for supported objects

XML Schema Collection XML Schema Collection

Aliases for table objects Aliases for table objects (table, view, stored procedure, function, synonym, sub-query)

Suggested conditions for JOIN statements Suggested conditions for JOIN statements

Suggested keywords Suggested keywords

Built-in data types Built-in data types

User data types User data types

Built-in functions Built-in functions starting with @@

Local and cursor variables Local and cursor variables

Function and procedure in parameters Function and procedure in parameters

!Out parameters for procedures Out parameters for procedures

Collations Collations

Cursors Cursors

Labels Labels

Languages Languages

Snippets Snippets

Procedures Procedures

Users Users

Roles Roles

Download dbForge Studio for SQL Server and try it absolutely free for 30 days!