Sql, Data, Data Science, Database, Data Visualization.
TRANSFER live.table2; -- step 3 of swap logic ALTER SCHEMA live TRANSFER staging.table1; ALTER SCHEMA live TRANSFER staging.table2; -- step 4 of swap logic ALTER SCHEMA staging TRANSFER swap.table1; ALTER SCHEMA staging TRANSFER swap.table2; COMMIT TRANSACTION [Swap] END TRY BEGIN CATCH ROLLBACK