Differentiate between ALTER and UPDATE

ALTERUPDATE
ALTER is a DDL statementUPDATE is a DML statement
ALTER is a SQL command that is used to modify, delete or add a column to an existing table in a database.UPDATE is a SQL command that is used to update existing records in a database
ALTER command modifies the database schema (structure)UPDATE statement only modifies records in a database without modifying its structure.

Leave a Comment

Your email address will not be published. Required fields are marked *

error: Content is protected !!