This document is archived and information here might be outdated.  Recommended version.


ISqlWorkspace Interface (ArcObjects .NET 10.5 SDK)
ArcObjects Library Reference (GeoDatabase)  

ISqlWorkspace Interface

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
Method CheckDatasetName Returns unique name in the workspace.
Method GetColumns Returns column information for a table.
Method GetQueryDescription Get query properties including spatial based on the first record of the query.
Method GetTables Returns names of all the table.
Method OpenQueryClass Returns a table or a feature class based on a query.
Method 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".