Is it possible to run multiple DDL statements inside a transaction (within SQL Server)?

by

I know most databases have restrictions, but Postgres doesn’t. You can run any number table creations, column changes and index changes in a transaction, and the changes aren’t visible to other users unit COMMIT succeeds. That’s how databases should be! 🙂

As for SQL Server you can run DDL inside of a transaction, but SQL Server does not version metadata, and so changes would be visible to others before the transaction commits. But some DDL statements can be rolled back if you are in a transaction, but for which ones work and which ones don’t you’ll need to run some tests.

More Related Contents:

  1. SQL Server – transactions roll back on error?
  2. Is it possible to roll back CREATE TABLE and ALTER TABLE statements in major SQL databases?
  3. What happens to an uncommitted transaction when the connection is closed?
  4. Correct use of transactions in SQL Server
  5. What does a transaction around a single statement do?
  6. SQL query rows as columns [duplicate]
  7. get quarter of current date in sql server 2008 [closed]
  8. How do I split a string so I can access item x?
  9. Why do we always prefer using parameters in SQL statements?
  10. Convert Rows to columns using ‘Pivot’ in SQL Server
  11. How Stuff and ‘For Xml Path’ work in SQL Server?
  12. SQL Server : Columns to Rows
  13. get a comma delimited string from rows [duplicate]
  14. Find all tables containing column with specified name – MS SQL Server
  15. SQL NVARCHAR and VARCHAR Limits
  16. How important is the order of columns in indexes?
  17. Why no windowed functions in where clauses?
  18. T-SQL: Round to nearest 15 minute interval
  19. T-SQL Cast versus Convert
  20. What is a stored procedure?
  21. T-SQL datetime rounded to nearest minute and nearest hours with using functions
  22. convert Excel Date Serial Number to Regular Date
  23. Partition Function COUNT() OVER possible using DISTINCT
  24. How can I do a BEFORE UPDATED trigger with sql server?
  25. T-SQL – Aliasing using “=” versus “as” [closed]
  26. How to install localdb separately?
  27. Drop all tables whose names begin with a certain string
  28. The object ‘DF__*’ is dependent on column ‘*’ – Changing int to double
  29. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  30. Drop column from SQLite table

Leave a Comment