I have a relational database that uses SQL. I am implementing a new features that requires adding a new column.

This means that I have to go about to all instances of my DB across all my environments and add the column.

There has to be a better way, I am imagining a way to describe the schema of my tables in a text file and when my server starts up it will see the differences between my DB and my file and will apply the new changes to the DB in that environment.

This has the added benefit that it is easier for code reviewer to see the changes I want to apply to our DB.

Is there a tool like this? Or another way to solve my problem?