What is Alter Script?
An alter script is a log of changes made in a data model, which in turn can be synchronized between databases. The script is generated by a data modeling tool and is usually executed using third-party software.
Database tables are created and edited with statements that add, change, and / or delete values that collectively define the entire database. Each of these statements has a very specific function, and while it can be difficult to keep track of every single statement that is made in the creation and / or modification of a model or database, it is important to do so accurately. For this and other reasons, Alter scripts are useful for creating and / or modifying databases in realtime. An alter script can log certain changes to a model that can be synchronized with others.