ApexSQL Edit

Beyond SSMS...

A tool for true SQL coders

Code complete, source control, refactors, formatting
and more all in a single, powerful IDE

Order online
from $499
Contact us for volume discounts
ApexSQL Bundles
For $800 more get 12 more products!
  • All 13 ApexSQL Developer tools
  • 1 year free support and upgrades
Free 90 day trial

 Datasheet: Formatting screen mockups and examples

Performance improvements  
Additional auto-complete options  
SQL Server 2012 support  
Improved object search     Search for objects in system databases
Version-aware editing     Update live objects, versioned scripts, or both with a single click
Enhanced auto-complete   Fill in keywords and database, schema, object and parameter names
Auto-complete pick list   Complete JOIN statements and cross-database queries automatically
Auto-complete object details   View object’s description and definition
Advanced SQL formatting   Format your SQL with over 160 customizable options and preview the changes’ impact
Native support for the most popular source control providers   Including Visual Source Safe, Subversion, Team foundation Server and SourceGear Vault
Support for all MSSCCI compliant versioning systems
Syntax highlighting   Locate and quickly fix syntax errors in the SQL code
SQL templates   Jumpstart code writing using built-in templates for commonly used SQL statements. Create your own templates to save on development time
Snippets   Save frequently used code structures as snippets and insert context-specific values as needed
Auto-replacements  Define text to be replaced with preformatted formatted SQL code blocks
Visual query builder  Simply drag and drop tables and views to build complex queries. Group, sort and filter the result sets visually
SQL debugging   Set breakpoints and manage conditional breakpoints. Step in, over or through your code and view variable values and temporary table contents
Code profiler   Identify the slowest statements in your code. View variable and parameter history
Expand wildcards  Transform * wildcards into explicit lists of column names
Qualify object names   Clarify your code qualifying columns with schema and table names 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
Find unused parameters and variables (code refactor)  Clean up your code by identifying and removing parameters and variables that aren’t used
Encapsulate as (code refactor)  Convert blocks of SQL code into scalar or table functions, stored procedures and views. Automatically identify and create the input parameters
Change parameters (code refactor)  Add, remove or change parameters without breaking dependencies from referencing objects
Replace one-to-many relationships with associative tables (code refactor)  Add a new associative table to replace one-to-many relationships
Add surrogate key (code refactor)  Replace complex, multi-column primary keys with a single column surrogate key
Object search  Search for objects or text in database object definitions
Text search  Search for text, numbers, dates and unique identifiers in your tables and views
Graphical dependencies  Visualize even the most complex relationships between objects
Customizable shortcuts
Transparent decryption
Support for all SQL Server versions