SQL Add Column Int

This page discusses - SQL Add Column Int

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

 

Advertisements

Share on Google+Share on Google+

SQL Add Column Int

Posted on: April 18, 2011 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Advertisements

Ads
 

Discuss: SQL Add Column Int  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0

Ads

 

Ads