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.

Database

Theme

Enter - Select * from table_name;

Output

#	Program	Language
1	Sql Query to Truncate Table	SQL
2	Sql Query To Update Multiple Column	SQL
3	Sql Query To Drop Table	SQL
4	Sql Query To Use a ' SELECT ' statement with LIMIT	SQL
5	Sql Query To Use DEFAULT Constraint	SQL
6	Sql Update Query Without Where Condition	SQL
7	Sql Query To Use a ' SELECT ' statement with AND Operator	SQL
8	Sql Case Sensitive Example 3	SQL
9	Sql Query To use a ' SELECT ' statement with COUNT() function	SQL
10	Sql Query To Use a ' SELECT ' statement with LIKE Clause	SQL
11	Sql Query To Use a ' SELECT ' statement with AVG() function.	SQL
12	Sql Query To Retrieve Record Using Where Condition	SQL
13	Sql Query To Use a ' SELECT ' statement with OR Operator	SQL
14	Sql query to use BETWEEN Operator	SQL
15	Sql Query to Create View	SQL
16	Sql Query To Use a Inner Joins	SQL
17	Sql Query To Insert The Record In The Table Without Defining The Column Name.	SQL
18	Sql Query to Delete Records	SQL
19	Sql Query to retrieve data using Order By in Ascending and Descending Order in priority	SQL
20	Sql Case Sensitive Example 1	SQL
#	Program	Language