Schema Usage Property
The Schema Usage property returns a bitmask specifying how schema names can be used in text commands.
Applies To
| Connection Object |
Syntax
object.Properties("Schema Usage")
Parts
object
Expression that evaluates to an object in the Applies To list.
Returns
A combination of zero or more of the following settings:
| Constant | Description |
|---|---|
| DBPROPVAL_SU_DML_STATEMENTS | Schema names are supported in all data manipulation language (DML) statements. |
| DBPROPVAL_SU_TABLE_DEFINITION | Schema names are supported in all table definition statements. |
| DBPROPVAL_SU_INDEX_DEFINITION | Schema names are supported in all index definition statements and may apply only to the table name, not the index name, depending on the SQL implementation. |
| DBPROPVAL_SU_PRIVILEGE_DEFINITION | Schema names are supported in all privilege definition statements. |
Data Type
adInteger
Modifiable
Read-only
OLE DB Property
DBPROP_SCHEMAUSAGE