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

ApexSQL Bundles

Learn more

	For $800 more get 12 more products!
	ApexSQL Developer Studio All 13 ApexSQL Developer tools 1 year free support and upgrades

Related products

	ApexSQL Doc Document SQL instances, databases and SSIS packages
	ApexSQL Diff Compare and synchronize SQL database objects

Free 90 day trial

Resources

Version: 2011.02

	Support forum		Knowledgebase
	FAQs		Troubleshooting
	News		Release notes
	Documentation		System requirements

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

Products	Download	Purchase	Support	News	Company
Value bundles	Installer	PDF price list	Support center	Blog	Why ApexSQL?
Database administration	Pre-releases	License	Support forum	What's new	Jobs
SQL development	System requirements	Resellers	Support FAQs	What's next	Gear
Add-ins	Version information	Competitive upgrades	Troubleshooting	Press releases	Contact us
Programmable APIs			Knowledgebase	Product updates
All ApexSQL tools			Documentation
			Product videos

Beyond SSMS...

A tool for true SQL coders

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

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