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
	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.

.NET Related Topics

Querying geodatabase tables