SQL Add Column Int

SQL Add Column Int is used to add new column, whose field data type is
integer.
Understand with Example
The Tutorial illustrate a SQL Add Column Int example .In this Tutorial we
create a table Stu_Table using create statement. The insert into add
the records or rows to the table. The select statement return you the
records from a table 'Stu_Table'.
Create Table Stu_Table
create table Stu_Table(Stu_Id integer(2), Stu_Name varchar(15))
|
Insert data into 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 is used to alter the table
table_name.The Add keyword is used to add a new column in a table.
ALTER TABLE table_name
ADD column_name column-definition
|
SQL Add Colum Query
The given below example shows you a modified
Stu_Table using Alter keywords, which add a new column Stu_Class
using add keyword, whose data is integer type.
Alter Table Stu_Table add Stu_Class int(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 |

|