With the help of ALTER Command, we can add columns to an existing table. This command allows you to drop a column also. The query that can be used to add a column into the existing one is-

ALTER TABLE dbo.StudentRcords ADD hobbies VARCHAR(50) NULL;

NOTE- You have to make the hobbies column NOT NULL or have to give a default value to it, otherwise the above query won’t work.

BY Best Interview Question ON 09 Jan 2021