In simple terms, the difference between update and alter, such as
Right-click Properties
Update Everymatchinfo SET matchno=111--Updating permissions
ALTER TABLE EVERYMATCHINFO add IDD INT--Change permissions
The actual is the difference between DDL and DML, with some brief instructions
DML (Data Manipulation language) is the language of the manipulation: they are select, UPDATE, INSERT, DELETE, just like its name, these 4 commands are the languages used to manipulate the data in the database.
DDL is a data definition language: DDL is more than DML, the main commands are create, alter, DROP, etc., the DDL is used to define or alter the structure of tables (table), data types, language, The links between tables and constraints such as initialization work, most of them are used when establishing tables.
DCL(datacontrollanguage) is a database control language: A statement that is used to set or change permissions for a database user or role, including (Grant,deny,revoke, etc.) statements.
Reference: http://www.cnblogs.com/seasons1987/archive/2013/06/13/3134012.html
Differences between update and change at SQL Server account permissions