ApexSQL Edit可與大多數(shù)的MSSCCI-compliant Source Control systems集成

ApexSQL Edit支持大多數(shù)MSSCCI-compliant source control system，比如Visual Source Safe 和 Team Foundation Server.

數(shù)據(jù)庫瀏覽功能

有了Schema Explorer，用戶可以瀏覽服務器，數(shù)據(jù)庫和個人信息。通過他們各自的內容菜單，用戶可以進行多項操作。

可視化管理對象，快速顯示數(shù)據(jù)。

ApexSQL Edit最強大的特性之一是Object Explorer。有了Object Explorer，在一個簡潔的表格中，你就可以對對象就行分類、分組和管理。通過一些額外功能鍵，你也可以瀏覽對象元數(shù)據(jù)、依懶關系和腳本等信息。

可視化查詢Database Schema和腳本信息。

有了Intelliprompt，你就可以專心為你的數(shù)據(jù)庫對象寫SQL，而不用過多的關注列、表和變量名等細節(jié)。Intelliprompt不僅可以極大地提高您的SQL編寫時間，而且可以極大地減少拼寫和句法錯誤。

提供更多可讀化代碼

ApexSQL為BEGIN和END等命令消除器中的可折疊代碼提供一個Visual Studio（類似于顯示你的SQL代碼）。

跟蹤并顯示嵌入在你代碼中的對象。

當你寫代碼時，控件提示功能將會顯示對對象的描述或者句法。

編輯數(shù)據(jù)

通過ApexSQL Edit，您可以閱讀并編輯數(shù)據(jù)。篩選、分類、分組和編輯都可以在同一個界面上完成。

可視化查詢

ApexSQL Edit提供了一個強大的可視化查詢編輯器，它可以支持您的復雜查詢。

通過Auto-Replacements避免拼寫和句法錯誤。

使用ApexSQL Edit中的auto-replacement功能，您可以設置一些自動糾錯的單詞。

通過Code snippets提高效率

Code Snippets有這樣一項功能：在程序片段中定義替代詞，而在文檔的最后用戶又可以恢復完整程序。通過這項功能，您可以提前定義SQL和代碼塊。Snippets提供多種功能，包括在最后的文檔中自動設置光標定位。

對象查詢

通過Object Search，您可以查詢與在SQL中的對象名相匹配的文檔。

有了Object Search，您可以在支持通配符和寬松連接的數(shù)據(jù)庫中查詢任何對象。

文檔查詢

Text Search功能可以查詢在表和視圖中匹配的數(shù)據(jù)文檔。通過檢查在表和視圖名旁邊的boxes，你可以找出你所需的對象。當然您也可以使用附加的過濾選項來進行部分匹配查詢，比如查詢文檔類型表，查詢數(shù)據(jù)表，查詢唯一標示符表和查詢視圖。

完全自定義菜單和功能

ApexSQL Edit支持對特殊對象進行自定義。比如：雙擊Table表示打開并編輯它，但是雙擊Procure可能意味著向您展示它的腳本。對一個特定的對象，可以設計新的菜單，并把這些新菜單加入已存在的文本菜單中。

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.