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

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

Other properties of group

Other sets of properties