MSSQL can roll back DDL. But the DDL changes are not fully transactional, as other trans sacri one can see new columns and tables before the DDL transacrion commits.

Postgres gets it right. DDL is contained in the transacrion until commit.