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