DBPROP_SUPPORTEDTXNDDL
Property group: Data Source Information
Property set: DBPROPSET_DATASOURCEINFO
Type: VT_I4
Typical R/W: R
Description: Transaction DDL
Indicates the relationship of transactions to table and index modification data definition language (DDL) statements. One of the following:
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 DBPROP_COMMITPRESERVE. If the provider was in auto-commit mode, it remains in auto-commit mode, and likewise for manual-commit mode.
DBPROPVAL_TC_DDL_IGNORE ? Transactions can contain only DML statements. Attempts to modify tables or indexes within a transaction are ignored.
Note
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.