ApexSQL Refactor 2017.02
ApexSQL Refactor is a free SQL formatter and database refactoring tool for SQL Server. Format SQL queries, refactor SQL code, database tables. It expands wildcard, fully qualifies object names, renames SQL database objects
Product Specifications
| User Rating: | item has less then 1 vote |
|
| FileCart Rating | ||
| Submitted by: | Brian Lockwood | |
| Homepage | Visit Homepage | |
| License | Freeware | |
| Expires | 14 Days | |
| Price | $0.00 | |
| Downloads | 1,249 | |
| OS Support | Windows Install and Uninstall | |
| File Name | ApexSQLRefactor.exe | |
| File Size | 6.84 MB ( 7,000 KB ) | |
| Published | Nov 18, 2009 (14 years ago) | |
| Updated | Jul 27, 2018 (6 years ago) | |
Follow Us!
Latest Searches
ChequeSystem Cheque Printing Software 14 hours ago
2024 18 hours ago
Cut and fill volume in AutoCAD 23 hours ago
2025 1 day ago
2023 2 days ago
FURNIT 2 days ago
Nord 3 days ago
realtek audio driver windows 10 3 days ago
TRIANGULATION for AutoCAD 3 days ago
Popular Searches
Database Workbench Pro 258 times
TeraByte Drive Image Backup and Restore 255 times
Elcomsoft Phone Breaker 251 times
Elcomsoft Phone Viewer 232 times
Softperfect 230 times
SAM Broadcaster Cloud 223 times
BootIt Collection 223 times
YetiShare File Hosting Script 207 times
Antamedia HotSpot Software 205 times
Product Details
ApexSQL Refactor is a free SQL formatter and database refactoring tool for SQL Server. Format SQL queries, refactor SQL code and database tables with ease. It can format and refactor code directly in SSMS or MSVS, qualify objects, expand wildcards, encapsulate SQL, locate and highlight unused variables and parameters, and much more for FREE.
Features:
- Support for SQL Server 2005 and above
- Support for Visual Studio 2010 and above
- Split table: Improve your database design and make large tables more manageable by partitioning them
- Advanced SQL formatting: Create custom formatting profiles and share them across your team
- Customizable options: Layout your SQL code with over 200 customizable options and preview the impact of the changes
- Impact analysis: Preview the impact of changes with difference highlighting
- Expand wildcards: Transform * wildcards into explicit lists of column names
- Qualify object names: Qualify columns with schema table names and schema or aliases
- Copy SQL code as: Render T-SQL into its Java, C#, C++, VB .NET, PHP, Ruby, Delphi or PowerBuilder equivalent. Copy and paste it into your applications data access layer
- Add surrogate key: Replace complex, multi-column primary keys with a single column surrogate key
- Find unused variables and parameters: Clean up your code by identifying and removing parameters and variables that aren?t used
- Replace one-to-many relationships: Add a new associative table to replace one-to-many relationships
- Change parameters: Add, remove or change parameters without breaking dependencies from referencing objects
- Encapsulate SQL: Convert blocks of SQL code into scalar or table functions, stored procedures and views. Automatically identify and create the input parameters
- SQL Server 2017 CTP 2 support
- SQL Server Management Studio integration
- Smart indent feature
- Batch format SQL objects feature
- Obfuscate SQL feature
- Visual Studio 2017 integration
Features:
- Support for SQL Server 2005 and above
- Support for Visual Studio 2010 and above
- Split table: Improve your database design and make large tables more manageable by partitioning them
- Advanced SQL formatting: Create custom formatting profiles and share them across your team
- Customizable options: Layout your SQL code with over 200 customizable options and preview the impact of the changes
- Impact analysis: Preview the impact of changes with difference highlighting
- Expand wildcards: Transform * wildcards into explicit lists of column names
- Qualify object names: Qualify columns with schema table names and schema or aliases
- Copy SQL code as: Render T-SQL into its Java, C#, C++, VB .NET, PHP, Ruby, Delphi or PowerBuilder equivalent. Copy and paste it into your applications data access layer
- Add surrogate key: Replace complex, multi-column primary keys with a single column surrogate key
- Find unused variables and parameters: Clean up your code by identifying and removing parameters and variables that aren?t used
- Replace one-to-many relationships: Add a new associative table to replace one-to-many relationships
- Change parameters: Add, remove or change parameters without breaking dependencies from referencing objects
- Encapsulate SQL: Convert blocks of SQL code into scalar or table functions, stored procedures and views. Automatically identify and create the input parameters
- SQL Server 2017 CTP 2 support
- SQL Server Management Studio integration
- Smart indent feature
- Batch format SQL objects feature
- Obfuscate SQL feature
- Visual Studio 2017 integration
| Requirements: | MSSQL Server 2017, 2016, 2014, 2012, 2008, 2005; Azure SQL Database; .NET 4.5 |
| Release Info: | Major update on May 08, 2017 |
| Release Notes: | Major feature, major fix release |
| Related Tags: | format sql sql formatter sql server refactor sql sql refactor |
Reviews
You must be logged in to write a review
Reviews of ApexSQL Refactor 2017.02
You can be the first to write a review of ApexSQL Refactor!Other products submitted by this publisher
ApexSQL Build-builds or updates existing SQL Server databases, creates deployment SQL scripts, C# projects and packages. It creates deployment scripts, projects and packages from SQL scripts, script folders, snapshots, or directly from source control
ApexSQL CompleteApexSQL Complete can automatically fill in SQL keywords, statements and identifiers. It integrates seamlessly with SSMS and MSVS. ApexSQL Complete helps with object script and description reviews without coding interruption
ApexSQL SearchApexSQL Search analyzes SQL Server database object's dependencies within the database, across databases, scripts and even applications. It recognizes all database dependencies, even those not recognized by SQL Server itself.
Most Viewed Windows Database Tools
EMS SQL Manager for SQL Server 3.9
DBF Viewer 2000 6.55
DataNumen Access Repair 2.2
PHP DataGrid AJAX Enabled Web Control 8.2.7
Universal SQL Editor 1.9.2.2
Excel-Mysql converter 3.0
xBaseView Database Explorer 11.0
Data Loader 4.8
Altova MapForce Enterprise Edition 2017sp2