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

Related Tags for SQL Add Column:

«Previous Index Next»