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 VS, qualify objects, expand wildcards, encapsulate SQL, locate and highlight unused variables and parameters, and much more for free.
SQL Server 2014 support: Format and refactor your code directly in SQL Server 2014 Management Studio. Refactor SQL Server 2012 objects including FileTables .
Support for all Visual Studio versions: Format and refactor SQL code in Visual Studio 2013.
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 160 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.
MSSQL Server 2014, 2012, 2008 or 2005 with with Microsoft SQL Management Studio 2005 with SP2
Like it? Share with your friends!
Other Windows Software of Developer «ApexSQL»:
Apex SQL Build ApexSQL Build creates or updates existing DB's creating deployment SQL scripts, C# packages or .NET executables. It creates deployment scripts, packages and executables from SQL scripts, script folders, snapshots or source control, consolidates multiple sc
Apex SQL Doc ApexSQL Doc creates database documentation in a variety of formats. Document SQL Servers, databases, objects and SSIS packages in a single document. Render even the most complicated database into user friendly documentation with inline object descriptions,
ApexSQL Audit ApexSQL Audit allows you to seamlessly integrate data auditing and reporting into your client applications, it can help you audit and undo SQL database changes and easily determine who and when changed the data. ApexSQL Audit is compatible with all SQL Ser
ApexSQL Doc ApexSQL Doc creates database documentation in a variety of formats. Document SQL Servers, databases, objects and SSIS packages in a single document. Render even the most complicated database into user friendly documentation with inline object descriptions,
ApexSQL Log API ApexSQL Log API programmatically reads SQL Server Transaction Log. View transaction log data and audit changes programmatically. Find out exactly when and how an accident occurred as well as details on who was involved. Add schema and data auditing capabil
ApexSQL Script ApexSQL Script is a SQL Server database migration tool which scripts database object and data into a single or multiple deployment SQL scripts, .NET solutions or executable installers. It can export live databases directly to version control and can automa
ApexSQL Search ApexSQL 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. Search for SQL objects directly
ApexSQL Comply ApexSQL Comply is a powerful SQL Server auditing tool with a wide range of possibilities for auditing access, changes, and security on SQL Server instances, databases, and objects. It audits queries, execute and security (authentication changes, permission
ApexSQL Restore ApexSQL Restore is a SQL Server tool that attaches both native and natively compressed SQL database backups and transaction log backups as live databases, accessible via SQL Server Management Studio, Visual Studio or any third-party tool. It allows attachi
ApexSQL Clean ApexSQL Clean analyzes SQL Server database objects, dependencies within the database, across databases, scripts and even applications. It recognizes all database dependencies, even those not recognized by SQL Server itself. ApexSQL Clean helps you remove u
DBSync for FoxPro & MSSQL DBSync for FoxPro & MSSQL is a reliable bi-directional database migration tool which allows you to synchronize and convert from:
MS Visual FoxPro to MSSQL
MS Visual FoxPro to MS Visual FoxPro
MSSQL to MS Visual FoxPro
MSSQL to MSSQL
Scan To PDF Network Scanner OCR Solution The ideal solution for monitoring network folders for documents produced by networks scanners and processing barcoded documents in batches and creating fully text searchable PDF documents, all in one bundle, packed and ready to go. Scan batches of * Invoic
DataSlave Map Editor DataSlave is a powerful tool for moving data. DataSlave supports many common data formats and will quickly and simply move, validate, de-duplicate and clean your valuable data. This difficult task is now available to users without the need for any progra
Vehicle Manager Professional Edition Vehicle Manager is an application to track your vehicle's service schedule and service history. Vehicle Manager allows you to create a service schedule for each vehicle as well as maintaining the history of all services for each vehicle. You will be remind
PostgreSQL Editor Software This software offers a solution to users who want to edit data in PostgreSQL tables. The user simply enters the login information for the required database and tests the connection before proceeding to the user-friendly interface to edit data as required.
SSuite Office MonoBase Features that are available in Monobase are these, create unlimited databases with unlimited tables, fields, and rows (Paradox). Access any ODBC compatible database of any size, provided you have the ODBC drivers installed. Filter tables instantly. Run SQL
Excel Add-In for Office 365 The Office 365 Excel Add-In is a powerful tool that allows you to connect with live data from Office 365, directly from Microsoft Excel. Use Excel to read, write, and update Outlook Mail, Contact, Calendar, Files, etc. Perfect for mass imports / exports /
CSV Viewer CSV Viewer is a small and free CSV file viewer, it can help you to quickly open and view the content of one CSV file, you can select, copy, sort and find all data in the CSV file, it is easy to use very much.
EMS Data Import for DB2 EMS Data Import for DB2 is a tool to import data to DB2 tables from MS Excel 97-2007, MS Access, DBF, XML, TXT, CSV, MS Word 2007, RTF, ODF, and HTML files. It provides adjustable import parameters, including source data formats for all the fields and dest
Excel Oracle Import, Export & Convert Software This software allows you to use MS Excel as a front-end interface to an Oracle database by importing and exporting tables between the two. Now you can read and write Oracle tables without SQL knowledge. Excel 2000 or higher required.Requirements:Microsoft
Supported Operating Systems:
Windows 7 |
Windows 8 |
Windows Server 2008 |
Windows Vista |
Comments on ApexSQL Refactor:
Comments not found
Windows Software - Free Windows Downloads, Apps, Games, Freeware, Skype, Media Player, Antivirus, Gimp, Live, Starter for Windows XP, Vista, 7, 8, 10