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)
• 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)
• 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