How will you add a new column to an existing table in SQL?
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