ExecuteSQL Command for ArcMap

工具下载链接：http://arcscripts.esri.com/details.asp?dbid=16174

During the Implementing Enterprise Applications with the Geodatabase presentation at the 2009 ESRI Developer Summit a couple weeks ago, we talked about a handy tool that can be added to ArcMap to send SQL to the connected database. This tool uses the IWorkspace.ExecuteSQL method and it can be very useful in starting and stopping a DBMS trace directly from ArcMap when profiling an operation

大概意思就是可以用这个工具在arcmap中对geodatabase执行sql操作，这个和AE中的IWorkspace.ExecuteSQ类似，该接口就是利用ArcEngine的工作空间来执行SQL语句，效率比常规的操作更快，效率更高。

这个是AE中的介绍：

The ExecuteSQL method can be used to send an arbitrary SQL statement to the underlying database for execution. The statement can be any DDL (data definition language) or DML (data manipulation language) statement but can not return any result sets. The syntax for the SQL is as required by the underlying database. The workspace supports an optional ISQLSyntax interface that provides information to applications on aspects of the SQL Syntax for the underlying database.

To determine if a workspace supports the ExecutesSQL method, an application can check the value of the canExecuteSQLworkspace property via the optional IWorkspaceProperties interface. In general, this method is only supported on local and remote database workspaces.

相关的AE代码例子：

http://wenku.baidu.com/view/2d475304e87101f69e319503.html （ArcEngine数据删除几种方法和性能比较）