Write and execute SQL statements

Last modified: May 28, 2025

This section covers essential features for writing, formatting, and executing SQL statements in dbForge Studio. It includes code completion, renaming objects and variables, context-based prompts, working with aliases and parameters, managing code snippets, navigating SQL documents, and running scripts both within the IDE and from the command line.

In this section

Code completion

Rename SQL Server objects

Rename variables

Context-based prompts

View server messages and errors

Insert suggestions for code completion

Work with SQL aliases

Object and parameter info

Phrase auto-completion

Query formatting

Expand wildcards in SQL statements

Write SQL queries with code completion

Navigate through SQL documents

Format SQL code

Execute SQL statements

Use parameters

Manage code snippets

Work with literals in code snippets

Query History

Execution warnings

Execute large SQL scripts

Associate windows with connections

SQL document keyboard shortcuts

Run scripts from the command line

Format code from the command line

Exit codes used in the command line for /execute

Exit codes used in the command line for /formatsql