Identifier Case Sensitivity Property
From ADO and SQL Server
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