Provides access to members that supply information about SQL functionality.
Members
Name | Description | |
---|---|---|
![]() |
FormatDatetime | Format a datetime value into a literal string. |
![]() |
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. |
![]() |
GetOperator | SQL operators. |
![]() |
GetSpecialCharacter | Special DBMS dependent SQL characters. |
![]() |
GetSQLInfo | SQL Syntax Information. |
![]() |
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. |
![]() |
TruncateToLimit | Truncate identifier to what database can support. |
ISQLSyntax2.FormatDatetime Method
Format a datetime value into a literal string.
Public Function FormatDatetime ( _
ByVal datetimeValue As Object, _
ByVal datetimeType As esriSQLDatetimeType _
) As String
public string FormatDatetime (
object datetimeValue,
esriSQLDatetimeType datetimeType
);
ISQLSyntax2.GetOperator Method
SQL operators.
Public Function GetOperator ( _
ByVal sqlOperator As esriSQLOperator _
) As String
public string GetOperator (
esriSQLOperator sqlOperator
);
ISQLSyntax2.GetSQLInfo Method
SQL Syntax Information.
Public Function GetSQLInfo ( _
ByVal sqlInfo As esriSQLInfo _
) As Object
public object GetSQLInfo (
esriSQLInfo sqlInfo
);
ISQLSyntax2.TruncateToLimit Method
Truncate identifier to what database can support.
Public Function TruncateToLimit ( _
ByVal Type As esriIdentifierType, _
ByVal identifier As String _
) As String
public string TruncateToLimit (
esriIdentifierType Type,
string identifier
);
Inherited Interfaces
Interfaces | Description |
---|---|
ISQLSyntax | Provides access to members that supply information about SQL functionality. |
Classes that implement ISQLSyntax2
Classes | Description |
---|