so I have
commit1 drop table blah
commit2 create table blah with diff schema
I revert commit1 what would be the state?
It will be a conflict. But you can commit the revert to a different branch and run both schemas at the same time. This provides a lot of flexibility! Check out https://www.dolthub.com/blog/2022-04-29-dolt-revert/ for some discussion of this.
CALL DOLT_REVERT('bad-commit-hash')
Works just like git revert: creates an inverse of the changes in the commit given and applies it as a patch.