ArcObjects Library Reference (GeoDatabase)  

ISQLSyntax Interface

Provides access to members that supply information about SQL functionality.

Product Availability

Available with ArcGIS Engine, ArcGIS Desktop, and ArcGIS Server.

Description

ISQLSyntax is an interface that returns which SQL predicates, clauses, and other database specific constraints are supported by a workspace.

Members

Description
Method GetDelimitedIdentifierCase True if DBMS's quoted identifiers are case sensitive.
Method GetFunctionName DBMS dependent SQL function names.
Method GetIdentifierCase True if DBMS's identifiers are case sensitive.
Method GetInvalidCharacters The list of invalid characters used in literals (if any).
Method GetInvalidStartingCharacters The list of invalid characters used in literals (if any).
Method GetKeywords The list of DBMS specific reserved keywords.
Method GetSpecialCharacter Special DBMS dependent SQL characters.
Method GetStringComparisonCase True if string comparisons are case sensitive.
Method GetSupportedClauses Supported SQL clauses.
Method GetSupportedPredicates Supported SQL predicates.
Method ParseColumnName Given a column name, determine its qualification parts.
Method ParseTableName Given a table name, determine its qualification parts.
Method QualifyColumnName Given a table name and column name, returns its fully qualified name.
Method QualifyTableName Given a database, owner, and table name, return its fully qualified name.

CoClasses that implement ISQLSyntax

CoClasses and Classes Description
Sde3Workspace (esriDataSourcesGDB) Esri SDE (3.x) Feature Database.
Sde4Workspace (esriDataSourcesGDB) Esri SDE (4.x) Feature Database.
SqlWorkspace (esriDataSourcesGDB) Sql workspace
VersionedWorkspace VersionedWorkspace Object.
Workspace Workspace Object.

Remarks

Applications should use the ISQLSyntax interface to help them construct SQL queries and where clauses using database-specific clauses, predicates and special characters.

.NET Related Topics

Querying geodatabase tables