What is the purpose of the ALTER statement in SQL?

The ALTER statement is used to modify the structure or properties of a database table. It can be used to add, modify, or delete columns in a table, change the data type, length, or constraints of columns, and modify indexes, constraints, default values, etc. With the ALTER statement, existing database tables can be changed and optimized to meet new requirements or fix errors.