| CARVIEW |
Select Language
HTTP/2 301
content-length: 0
cache-control: no-cache, no-store, must-revalidate
location: /sql-tools-refactor/
set-cookie: ASP.NET_SessionId=0jr3tsrnd3fehmhqaosvuosy; path=/; secure; HttpOnly; SameSite=Lax
set-cookie: QSTLB=33373962.1.4271802240.3361554944; path=/; httponly;secure ;
x-aspnet-version: 4.0.30319
x-ua-compatible: IE=edge,chrome=1
x-frame-options: SAMEORIGIN
strict-transport-security: max-age=31536000; includeSubDomains; preload
x-content-type-options: nosniff
referrer-policy: strict-origin-when-cross-origin
content-security-policy: upgrade-insecure-requests;
x-permitted-cross-domain-policies: None
permissions-policy: camera=(), microphone=(), payment=()
date: Wed, 30 Jul 2025 14:51:07 GMT
x-cache: Miss from cloudfront
via: 1.1 edeae73b6739dfac2745ed7b3be217fc.cloudfront.net (CloudFront)
x-amz-cf-pop: BOM54-P2
x-amz-cf-id: xpCmxxnYLbD6fHf79BKFfa-agfO17TSKgXCU_jdIdKQwPzh-11MjFA==
HTTP/2 200
content-type: text/html; charset=utf-8
cache-control: max-age=14400, s-maxage=86400
server:
x-aspnet-version: 4.0.30319
x-ua-compatible: IE=edge,chrome=1
x-frame-options: SAMEORIGIN
strict-transport-security: max-age=31536000; includeSubDomains; preload
x-content-type-options: nosniff
referrer-policy: strict-origin-when-cross-origin
content-security-policy: upgrade-insecure-requests;
x-permitted-cross-domain-policies: None
permissions-policy: camera=(), microphone=(), payment=()
date: Wed, 30 Jul 2025 14:51:08 GMT
content-encoding: gzip
vary: accept-encoding
x-cache: Miss from cloudfront
via: 1.1 edeae73b6739dfac2745ed7b3be217fc.cloudfront.net (CloudFront)
x-amz-cf-pop: BOM54-P2
x-amz-cf-id: vol3ILrO8OLoPKr3aDE_q6jH70D2vN1EZRfsG7eYXx_FS1KQOUiLXQ==
SQL formatter | ApexSQL
08:25
This is the end
SQL formatter
ApexSQL Refactor is a SQL Server Management Studio (SSMS) and Visual Studio formatting and refactoring add-in for SQL Server with nearly 200 formatting options and 15 refactors such as table partitioning, safe rename, wildcard expansion and more.
08:25
Benefits
-
SQL formatter with over 160 options
-
Qualify objects and expand wildcards
-
Encapsulate SQL into procedures
-
Add surrogate keys
-
Replace one-to-many relationships
-
Change procedure parameters
-
Safely rename SQL objects
-
Locate & highlight unused variables
-
Format SQL objects
-
Obfuscate SQL
Features
Impact analysis
Preview the impact of SQL formatter changes with difference highlighting
Advanced SQL formatting
SQL formatter with over 160 customizable options
SQL formatter profiles
Save and quickly toggle between different sets of formatting settings
Batch formatting of SQL objects
Use the database-level SQL formatter to format all script based objects e.g. stored procedures, in a database, quickly and easily. Learn more
Obfuscation
Make SQL code less readable
Wildcard expansion
Transform * wildcards into explicit lists of column names. Learn more
Object name qualifying
Qualify columns with schema table names and schema or aliases. Learn more
Find unused variables and parameters
Clean up your code by identifying and removing parameters and variables that aren’t used. Learn more
Safe rename
Rename tables, procedures, views, functions and columns risk-free. Learn more
Add surrogate key
Replace complex, multi-column primary keys with a single column surrogate key. Learn more
Replace one-to-many relationships
Add a new associative table to replace one-to-many relationships. Learn more
Change parameters
Add, remove or change parameters without breaking dependencies from referencing objects. Learn more
Encapsulate SQL
Convert blocks of SQL code into scalar or table functions, stored procedures and views. Automatically identify and create the input parameters. Learn more
Split table
Improve your database design and make large tables more manageable by partitioning them. Learn more
Convert to code
Render T-SQL into its Java, C#, C++, VB .NET, PHP, Ruby or Delphi equivalent. Learn more
Command Line Interface
Format SQL from the command line. Learn more
Resources and support
Related Topics
Testimonials
Hostcentric Inc.
The ApexSQL Refactor SQL formatter is a great help, and I'm glad to have found something that works well and is easy!
Alex Gadea Sr. VP of Operations, Hostcentric Inc.Software Developer Consultant
I'm a user of ApexSQL Refactor and I find it a really wonderful product.
Paolo FRANCESCHINI Software Developer ConsultantJeeves Information Systems AB
I tried the ApexSQL Refactor product and liked it a lot. This is something I have been thinking would make my life a lot easier.
Mathias Hedlund System Developer, Jeeves Information Systems ABPDP.com
I used ApexSQL Complete and ApexSQL Refactor. Both are well designed and include all the modern feature compare to other competitors. I found tons of customization options that makes your tools powerful.
Mohammad Sanati Software & Database developer, PDP.comCommunicus
ApexSQL Refactor is essential to keeping formatting standards on my team without getting overwhelmed. Everyone can format as they want, but when it’s production-ready, it all fits the standard. I reach for the formatter after every edit; it’s second-nature.
Steven Hibble Senior Database Developer, CommunicusGet started now
Seamlessly integrate a SQL query formatter directly into SQL Server Management Studio (SSMS) and Visual Studio.
Please wait...