SQLTeam.com | Weblogs | Forums

What is difference between Update and Alter commands?

sql2008

#1

Hiiii,

What is difference between Update and Alter commands?


#2

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


#3

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


#4

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