| ALTER | UPDATE |
| ALTER is a DDL statement | UPDATE is a DML statement |
| ALTER is a SQL command that is used to modify, delete or add a column to an existing table in a database. | UPDATE is a SQL command that is used to update existing records in a database |
| ALTER command modifies the database schema (structure) | UPDATE statement only modifies records in a database without modifying its structure. |