Integrate with most MSSCCI-compliant Source Control systems

ApexSQL Edit supports most MSSCCI-compliant source control system like Visual Source Safe and Team Foundation Server.

Browse Database schemas

Schema Explorer allows users to browse servers, databases, and individual objects. A variety of actions are available through their respective context menus.

Manage objects visually, view data quickly

One of the most powerful features of ApexSQL Edit is the Object Explorer which allows you to group, sort and manage objects in a powerful tabular format. Additional tabs allow browsing object metadata, dependencies, scripts and more.

Interrogate Database Schema collections and Scripting options visually

ApexSQL Edit's Intelliprompt allows you to focus on writing SQL statements for your database objects without focusing on the details of exact column, table and variable names. Not only can Intelliprompt significantly speed up your SQL writing time, but annoying typos and mistakes are also significantly reduced.

Enjoy more readable code

Collapsible regions in code on command eliminators like BEGIN and END to provide a Visual Studio like presentation of your SQL Code.

Get Hints and Descriptions of objects embedded in your code

When writing code, the tooltip feature displays object descriptions or syntax hints.

Edit Data

ApexSQL Edit allows users to view and edit data. Filter, sort, group, edit all in a single powerful interface.

Build queries visually

ApexSQL Edit includes a powerful visual query editor that allows you to build complex queries.

Avoid spelling mistakes and syntax errors with Auto-Replacements

With ApexSQL Edit's auto-replacement feature you can set it to ensure commonly misspelled words are corrected automatically.

Improve productivity with Code snippets

Code Snippets allow the user to predefine blocks of SQL/Code with the ability to define replacements throughout the snippet where users can customize the final inserted text. Snippets offer a variety of options including automatically setting cursor location in completed replacment text.

Object search

The Object Search feature searches for text matches in SQL objects names.

Object Search allows you to search for any objects within a specific database with support for wildcards and loose matching.

Text search

The Text Search feature searches for data text matches in tables and views. By checking boxes besides table and view names you are able to filter in only specific objects. Also you are able to choose additional filter options like search text type columns, search date columns, search UniqueIdentifier columns, search Views, to use partial matching.

Fully customize menus and behaviors

ApexSQL Edit allows full granular customization of menu actions (i.e. Double click) on an object specific basis. For example, double clicking a Table might open it for editing but double clicking a Procure might script it to the editor. Entirely new menus can be custom designed and added to the existing context menu for that object.