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