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

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