In SQL, which of the following command is used to modify a column in a table?

Explanation

SET The SET command is used with UPDATE to specify which columns and values that should be updated in a table. Syntax UPDATE Table name SET ColoumnName = ‘value’ WHERE Condition; UPDATE The UPDATE command is used to update existing rows in a table. UPDATE Table name SET ColoumnName = ‘value’ WHERE Condition; Alter The ALTER is used to add, delete, or modify columns in an existing table.and also used to add and drop various constraints on an existing table. Syntax: ALTER TABLE table_name ALTER COLUMN column_name datatype ; Create The CREATE DATABASE statement is used to create a new SQL database. Syntax CREATE DATABASE databasename; The CREATE TABLE statement is used to create a new table in a database. Syntax CREATE TABLE table_name ( column1 datatype, column2 datatype, column3 datatype, ....); Hence, The Alter command is used to modify a column in a table