Identifier Case Sensitivity Property
The Identifier Case Sensitivity property indicates how identifiers treat case in data definition commands or interfaces.
Applies To
| Connection Object |
Syntax
object.Properties("Identifier Case Sensitivity")
Parts
object
Expression that evaluates to an object in the Applies To list.
Returns
One of the following settings:
| Constant | Description |
|---|---|
| DBPROPVAL_IC_UPPER | Identifiers in SQL are case-insensitive and are stored in uppercase. |
| DBPROPVAL_IC_LOWER | Identifiers in SQL are case-insensitive and are stored in lowercase. |
| DBPROPVAL_IC_SENSITIVE | Identifiers in SQL are case-sensitive and are stored in mixed case. |
| DBPROPVAL_IC_MIXED | Identifiers in SQL are case-insensitive and are stored in mixed case. |
Data Type
adInteger
Modifiable
Read-only
OLE DB Property
DBPROP_IDENTIFIERCASE