How to add new column in a table?

To insert new column in a table we use ALTER query.


For example, if we consider the table employee we can write the query as:

by this query we see that a new column E_City has been added in table Employee.Further you can also insert values in column city by using update query.
insertion of a new column

Leave a Comment