docs: Clarify transaction support for DDL
docs: Clarify transaction support for DDL

Closes #8456

googleapis/google-cloud-dotnet,jskeet/gcloud-dotnet,googleapis/google-cloud-dotnet,googleapis/google-cloud-dotnet