SQL Add New Column (Alter)
December 17, 2022 2022-12-17 20:01SQL Add New Column (Alter)
Subhajit
SELECT * FROM EMPLOYEE
Here, when we select the Employee table, we will get 4 columns EmployeeId, FirstName, LastName and Age. Now, we are going to add another column Country in the table as follows
ALTER TABLE EMPLOYEE ADD Country VARCHAR(20)
No when we run the select command, we will get the Employee table with a new column “Country” as follows
Please comment and share if you like this post and tell us about how we can enhance our posts. Thanks.
