A transaction can be any solitary SQL statement, including a DDL statement.
When a request contains multiple statements, a DDL statement is only allowed in the following situations:
- The transaction is explicit, that is, bracketed by BEGIN TRANSACTION and END TRANSACTION statements.
- The DDL statement is the last statement in the transaction, that is, immediately followed by the END TRANSACTION statement.