Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

DBPROP_IDENTIFIERCASE

Property group: Data Source Information

Property set: DBPROPSET_DATASOURCEINFO

Type: VT_I4

Typical R/W: R

Description: Identifier Case Sensitivity

Indicates how identifiers treat case in data definition commands or interfaces (such as IIndexDefinition, IAlterTable, IAlterIndex, ITableCreation, ITableDefinition, and ITableDefinitionWithConstraints). For SQL providers, this refers to SQL data definition commands and storage in system catalogs. One of the following:

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.