What happens in the background(sql content db) when a version history is deleted?

i am trying to research a scenario of what is happening in the background (sql) when we delete a version history?

i am trying to use an sql profile but Im getting confused with all that logs that keeps inserting there.

All ideas are welcome.

Thank you very much.