Blog

SQL Add New Column (Alter)

SQL

SQL Add New Column (Alter)

				
					SELECT * FROM EMPLOYEE
				
			
SQL select

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

SQL_Alter

Please comment and share if you like this post and tell us about how we can enhance our posts. Thanks.

Subhajis