What is difference between Update and Alter commands?

abhik · July 19, 2016, 2:03pm

Hiiii,

gbritton · July 19, 2016, 2:15pm

Update changes data in a table
Alter changes the metadata of the table (e.g. column definitions)

jason_clark · July 20, 2016, 4:54am

ALTER is a DDL statement used to update the structure of the table.
UPDATE is a DML statement used to update data.

JeffModen · July 23, 2016, 3:31am

Sounds like an interview question to quickly find out if someone can actually spell "T-SQL".