Rules for Transactions Containing DDL Statements - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

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.