SQL Add Column

This page discusses - SQL Add Column

SQL Add Column

SQL Add Column

     

SQL Add Column is used to add a new column in the existing table.

Understand with Example

The Tutorial illustrate an example from SQL Add Column. To understand this example, we create a table 'Stu_Table'. The createtable statement construct a table name 'Stu_Table' with Table attribute like field name and data type.

Create Table Stu_Table

 

 

 

create table Stu_Table(Stu_Id integer(2), Stu_Name varchar(15))

Insert data into Stu_Table

The insert into add the records or rows into the table 'Stu_Table'.

insert into Stu_Table values(1,'Komal');
insert into Stu_Table values(2,'Ajay');
insert into Stu_Table values(3,'Rakesh');
insert into Stu_Table values(4,'Bhanu');
insert into Stu_Table values(5,'Santosh);

 Stu_Table

Stu_Id Stu_Name
1 Komal
2 Ajay
3 Rakesh
4 Bhanu
5 Santosh

SQL Add Column Syntax

The Alter Table modifies and ADD Keywords add a new column to the table. The Syntax for the Add Column is given as below:  

ALTER TABLE table_name
ADD column_name column-definition

SQL Add Colum Query

The given below Query define a Alter Table that modifies and add a new column 'Stu_Class' to the table 'Stu_Table'.

Alter Table Stu_Table add Stu_Class varchar(10)

View data  Stu_Table

Stu_Id Stu_Name Stu_Class
1 Komal NULL
2 Ajay NULL
3 Rakesh NULL
4 Bhanu NULL
5 Santosh NULL