How is ALTER different from UPDATE?


#1

Question

In the context of this exercise, how is ALTER different from UPDATE?

Answer

Although similar in the sense that both statements will modify a table, these statements are quite different.

The ALTER statement is used to modify columns. With ALTER, you can add columns, remove them, or even modify them.

The UPDATE statement is used to modify rows. However, UPDATE can only update a row, and cannot remove or add rows.