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

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

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

有了Schema Explorer，用戶可以瀏覽服務(wù)器，數(shù)據(jù)庫(kù)和個(gè)人信息。通過(guò)他們各自的內(nèi)容菜單，用戶可以進(jìn)行多項(xiàng)操作。

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

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

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

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

提供更多可讀化代碼

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

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

當(dāng)你寫(xiě)代碼時(shí)，控件提示功能將會(huì)顯示對(duì)對(duì)象的描述或者句法。

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

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

可視化查詢

ApexSQL Edit提供了一個(gè)強(qiáng)大的可視化查詢編輯器，它可以支持您的復(fù)雜查詢。

通過(guò)Auto-Replacements避免拼寫(xiě)和句法錯(cuò)誤。

使用ApexSQL Edit中的auto-replacement功能，您可以設(shè)置一些自動(dòng)糾錯(cuò)的單詞。

通過(guò)Code snippets提高效率

Code Snippets有這樣一項(xiàng)功能：在程序片段中定義替代詞，而在文檔的最后用戶又可以恢復(fù)完整程序。通過(guò)這項(xiàng)功能，您可以提前定義SQL和代碼塊。Snippets提供多種功能，包括在最后的文檔中自動(dòng)設(shè)置光標(biāo)定位。

對(duì)象查詢

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

有了Object Search，您可以在支持通配符和寬松連接的數(shù)據(jù)庫(kù)中查詢?nèi)魏螌?duì)象。

文檔查詢

Text Search功能可以查詢?cè)诒砗鸵晥D中匹配的數(shù)據(jù)文檔。通過(guò)檢查在表和視圖名旁邊的boxes，你可以找出你所需的對(duì)象。當(dāng)然您也可以使用附加的過(guò)濾選項(xiàng)來(lái)進(jìn)行部分匹配查詢，比如查詢文檔類型表，查詢數(shù)據(jù)表，查詢標(biāo)示符表和查詢視圖。

*自定義菜單和功能

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

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 commａnd 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.