Where should I keep the CREATE TABLE script?

Hi, I have a plan to create an API that uses MySQL as a database. I have never used SQL as a database before so I don't know where to keep the CREATE TABLE script. Should I just keep it in the API and run the script every time the server starts? Or should I just create a script and run it only when I want to update the schema?

Submitted January 25, 2020 at 10:56AM by 1t2t3t4t