Über dbForge SQL Complete

Fortschrittliches intellisense für SQL Server Management Studio (SSMS).

dbForge SQL Complete is an advanced solution for SQL database development, management, and administration. Available as an add-in for Visual Studio and SSMS, the tool offers excellent autocompletion capabilities. You can easily write, beautify, refactor your SQL code and boost your productivity with features that are missing from Management Studio and Visual Studio.

dbForge SQL Complete Features

Standard Edition includes:

Intelligent SQL Completion

  • Smart suggestions
  • Wise filtering in the suggestion list
  • Database context detection
  • Context-sensitive object suggestions for SELECT, DML, DROP, EXEC, SET, and USE statements
  • Parameter information for functions
  • Semi-transparent view of the suggestion box
  • Prompting common table expressions (CTE)
  • Visual Studio Integration
  • Context-sensitive suggestion of keywords
  • Quick object information
  • Name suggestions for objects on linked servers
  • Column picker for quick list building
  • JOIN clause auto generation
  • Wildcard expansion
  • INSERT, EXEC, and ALTER statements expansion
  • UPDATE statements expansion
  • Auto-generation of table aliases
  • Context-sensitive object suggestions for T-SQL code, DDL, and security statements
  • SQL snippets
  • Code completion in SQLCMD mode
  • Identifier occurrences highlighting
  • Sorting suggested keywords by relevance
  • Custom alias mapping
  • Phrase completion
  • Pair highlighting (BEGIN END; CASE END)
  • Highlight of matching COLUMNS and VALUES in the INSERT statement
  • Show popup with column name in the values area for INSERT statement
  • Get Row Count
  • Expanding sp_executesql
  • Named Regions
  • Data Sensitivity Classification suggestions

T-SQL Formatting

  • SQL formatting
  • Database identifier case synchronization
  • Word recognition in CamelCase identifiers
  • Formatting in files and directories
  • Adjust keyword case on typing
  • Disable formatting for a block of code (noformat tag)
  • Wide range of predefined formatting profiles

Productivity Extension

  • Execution History
  • Execute current statement

Professional Edition includes:

Intelligent SQL Completion

  • Smart suggestions
  • Wise filtering in the suggestion list
  • Database context detection
  • Context-sensitive object suggestions for SELECT, DML, DROP, EXEC, SET, and USE statements
  • Parameter information for functions
  • Semi-transparent view of the suggestion box
  • Prompting common table expressions (CTE)
  • Visual Studio 2019 Integration
  • Context-sensitive suggestion of keywords
  • Quick object information
  • Name suggestions for objects on linked servers
  • Column picker for quick list building
  • JOIN clause auto generation
  • Wildcard expansion
  • INSERT, EXEC, and ALTER statements expansion
  • UPDATE statements expansion
  • Auto-generation of table aliases
  • Context-sensitive object suggestions for T-SQL code, DDL, and security statements
  • SQL snippets
  • Code completion in SQLCMD mode
  • Identifier occurrences highlighting
  • Sorting suggested keywords by relevance
  • Custom alias mapping
  • Phrase completion
  • Pair highlighting (BEGIN END; CASE END)
  • Highlight of matching COLUMNS and VALUES in the INSERT statement
  • Show popup with column name in the values area for INSERT statement
  • Get Row Count
  • Expanding sp_executesql
  • Named Regions
  • Data Sensitivity Classification suggestions

T-SQL Formatting

  • SQL formatting
  • Database identifier case synchronization
  • Word recognition in CamelCase identifiers
  • SQL Formatting command-line interface
  • Formatting in files and directories
  • Adjust keyword case on typing
  • Disable formatting for a block of code (noformat tag)
  • Wide range of predefined formatting profiles

Code Refactoring

  • Enclosing needed identifiers in square brackets
  • Smart rename
  • Semicolon insertion
  • T-SQL Debugger
  • Find invalid objects

Productivity Extension

  • Execution History
  • Execute current statement
  • "Go to definition" for database objects
  • Document outline window
  • Statement navigation
  • Execution warnings
  • CRUD generator
  • Convert EXEC to script
  • Run script on multiple databases
  • Execution notifications
  • Transaction reminder
  • Find in Results Grid
  • Grid Aggregates
  • Navigation between the BEGIN and END pair
  • Navigation between BEGIN TRY/END TRY
  • Navigation between BEGIN CATCH/END CATCH
  • Navigation between CASE и END
  • Navigation between COLUMNS and VALUES in the INSERT statement
  • Generate Script As from SSMS data grid
  • Restore last document session
  • Custom SSMS main window title & SQL document tabs caption
  • Close unmodified tabs
  • Tabs coloring as well as Status bar and Object explorer coloring
  • Script object as CREATE/ALTER
  • Excluding databases from prompts
  • Copy Results Grid Headers (Column Names + Types)
  • Results Grid Data Visualizers
  • Proportional tab width and the ability to control what is displayed in the tab name