 |
This document is archived and information here might be outdated. Recommended version. |
ISqlWorkspace Interface (ArcObjects .NET 10.5 SDK)
|
This document is archived and information here might be outdated. Recommended version. |
| ArcObjects Help for .NET developers > ArcObjects namespaces > Geodatabase > ESRI.ArcGIS.GeoDatabase > Interfaces > IS > ISqlWorkspace Interface (ArcObjects .NET 10.5 SDK) |
Query layer workspace interface
This interface is used to create query classes and query cursors, and to retrieve information about SQL workspaces.
| 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 and Classes | Description |
|---|---|
| SqlWorkspace (esriDataSourcesGDB) | Sql workspace |
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".