Sql Query To Add Column Using ADD With ALTER Command

To add a column in the existing created table, then we can use an ' ALTER TABLE ' statement with ADD.

Here, we have added a status column with a default string as "ACTIVE" in a regions table of a Employee DB Database.

Enter - Select * from table_name;
SQL Query
ALTER TABLE regions ADD Status varchar(50) default ACTIVE; SELECT * FROM regions;