Updated: 2018-05-04
Data Source Initialization OLE DB Property — «auto_commit_ddl»
Name:
auto_commit_ddl
Type:
VT_I4
R/W:
R/W
Default:
0
IBProvider:
1, 2, 3, 5
DDL queries (CREATE/ALTER/DROP) execution mode. Allowed values:
| Value | Description |
| 0 | Support of DDL queries is off. |
| 1 | Executing DDL query in a transaction. Ignored if auto-commit mode. |
| 2 | Execute CommitRetaining after DDL query. Ignored if auto-commit mode. |
If you need to execute the mixed sequence of DDL and DML queries you should set the property to 1.
Default value (0) means that when using the explicit transaction control (auto_commit=false) the metadata update will applied only after commit.
See also
- The initialization property auto_commit
- The initialization property auto_commit_ddl_level
- The session property Session AutoCommit DDL
- The session property Session AutoCommit DDL Level