Page Template assignement

Where is the page assigned to a page template stored in the database?

i’ve looked but can’t find it.

I have over 33 page templates and in updating their filenames wordpress pages lose their connection, i would like to do this on my live server and i’m hoping to run some SQL to update the connections quickly rather than selecting each page and each page template through the admin panel.

thanks