The Transaction DDL property indicates the relationship of transactions to table and index modification data definition language (DDL) statements.
object.Properties("Transaction DDL")
object
Expression that evaluates to an object in the Applies To list.
One of the following settings:
| Constant | Description |
|---|---|
| DBPROPVAL_TC_NONE | Transactions are not supported. |
| DBPROPVAL_TC_DML | Transactions can contain only data manipulation language (DML) statements. Attempting to modify tables or indexes within a transaction causes an error. |
| DBPROPVAL_TC_DDL_COMMIT | Transactions can contain only DML statements. Modifying tables or indexes within a transaction causes the transaction to be committed. The provider's commit mode remains unchanged in accordance with the value of the Preserve on Commit property. If the provider is in auto-commit mode, it remains in auto-commit mode. If the provider is in manual-commit mode, it remains in manual-commit mode. |
| DBPROPVAL_TC_DDL_IGNORE | Transactions can contain only DML statements. Attempts to modify tables or indexes within a transaction are ignored. DDL operations are not transacted even if a session is participating in a transaction. If the DDL method succeeds, the operation is complete and unaffected by subsequent calls to abort or commit the transaction. |
| DBPROPVAL_TC_DDL_LOCK | Transactions can contain both DML and table or index modifications, but modifying a table or index within a transaction causes the table or index to be locked until the transaction completes. |
| DBPROPVAL_TC_ALL | Transactions can contain DML statements, as well as table or index modifications, in any order. |
adInteger
Read-only
DBPROP_SUPPORTEDTXNDDL