SQL Add Column Int

The Tutorial covers on 'SQL Add Column Int'.To understand and grasp the example we create a table 'Stu' with required fieldnames and datatypes respectively.

SQL Add Column Int

SQL Add Column Int

     

SQL Add Column Int modifies the definition of table and add a new column to the existing table.

Understand with Example

The Tutorial covers on 'SQL Add Column Int'.To understand and grasp the example we create a table 'Stu' with required fieldnames and datatypes respectively.

 

 

 

 

Create Table Stu

create table Stu(Id integer(2), Name varchar(15));

Insert data into Stu

Insert into adds the records or rows to the table Stu.

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

 Stu

Id Name
1 Komal
2 Ajay
3 Rakesh
4 Bhanu
5 Santosh

SQL Add Column Syntax

The Alter Column is used to modify the table definition and add a new column 'class' to the existing table. 

ALTER TABLE table_name
ADD column_name column-definition

SQL Add Column Query

Alter Table Stu add Class int(10);

Stu table

Id Name Class
1 Komal NULL
2 Ajay NULL
3 Rakesh NULL
4 Bhanu NULL
5 Santosh NULL