Query layer workspace interface
Product Availability
Available with ArcGIS Engine, ArcGIS Desktop, and ArcGIS Server.
Description
This interface is used to create query classes and query cursors, and to retrieve information about SQL workspaces.
Members
| Description | ||
|---|---|---|
 |
CheckDatasetName | Returns unique name in the workspace. |
|
GetColumns | Returns column information for a table. |
|
GetQueryDescription | Get query properties including spatial based on the first record of the query. |
|
GetTables | Returns names of all the table. |
|
OpenQueryClass | Returns a table or a feature class based on a query. |
|
OpenQueryCursor | Returns a cursor based on a query. |
CoClasses that implement ISqlWorkspace
| CoClasses and Classes | Description |
|---|---|
| SqlWorkspace (esriDataSourcesGDB) | Sql workspace |
Remarks
A SQL workspace is a relational database that may or may not be a geodatabase. After creating a workspace with the SqlWorkspaceFactory class (and the IWorkspaceFactory interface), this interface is used to retrieve data in a read-only manner as query classes and query cursors. Query classes can be used much like tables or feature classes from other data sources; through ArcMap, they are exposed as "Query Layers".