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