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 |