Question: what is the difference between alter and update in sql?
Answer: ALTER is used to update the structure of the table (add/remove field/index etc). Whereas UPDATE is used to update data. The ALTER changes the table in the database, you can add or remove columns, etc. ... ALTER is used to change things like table structures or stored procs, otherwise known as DDL statements.