ApexSQL Edit

ApexSQL Edit is an SQL Server code editor with advanced SQL formatting, refactoring and autocomplete functions. Edit SQL using code snippets, templates and more. Translate SQL code into a variety of programming languages. Encapsulate lengthy blocks of code as database objects. Auto-complete SQL code fragments and constructs. Leverage pre-written code snippets and templates to avoid writing frequently used code over and over. Develop faster with SQL code auto-complete, snippets and tags Integrate seamlessly with any source control system Improve your SQL code with formatting and refactoring Performance profile your SQL at the line level Features: - Improved performance - SQL Server 2012 support - Enhanced auto-complete - Auto-complete pick list - Auto-complete object details - Improved formatting engine - Version-aware editing - Syntax highlighting - Improved object search - Find unused variables and parameters (code refactor) - Encapsulate as view (code refactor) - Change parameters (code refactor) - Replace one-to-many relationships with associative tables (code refactor) - Add surrogate key (code refactor) - Additional support for SQL 2008 and SQL 2005 object types - Advanced SQL formatting - Native support for the most popular source control providers - Support for all MSSCCI compliant versioning systems - SQL templates - Snippets - Auto-replacements - Visual query builder - SQL debugging - Code profiler - Expand wildcards - Qualify object names - Copy SQL code as - Encapsulate as (code refactor) - Smart rename (code refactor) - Object search - Text search - Graphical dependencies - Customizable shortcuts - Transparent decryption - Support for all SQL Server versions