How to change the Sprite Pivot point?

For 2D top-down games, character and wall tiles should be able to overlap each other based on the position the character is, relative to the wall. So I changed the Transparent sort mode to custom Axis and set Y = 1. I will also need to set character and other sprites' Pivot point to button, but I did not see the generated tiles can be set to this. 