Can you use ALTER to add a new column with existing data into a table or you can only use UPDATE to add data into the newly added column

ALTER allows you to add or remove columns from a table, while UPDATE allows you to update row(s)/record(s) in the table.

1 Like