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

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

Related Tags for SQL Add Column Int:
sql,  c,  data,  integer,  sed,  type,  column,  new,  field,  int,  ie,  add,  to,  ld,  e,  use,  pe,  in,  m,  nt,  os,  dd,  os,  ad,  umn,  s,  col,  at,  is,  s,  s,  lum,  ol,  o

More Tutorials from this section

• SQL Example, Codes and Tutorials
• Aggregate Functions
• Backup File With Separator
• Backup Into txt File
• Backup selected records into txt file
• Call Procedure
• Close Cursors in SQL
• Create After Insert Trigger in SQL
• Create Before Insert Trigger in SQL
• Create Before Update Trigger in SQL
• Create Delete Trigger in SQL
• Create a Simple Procedure
• Create After Update Trigger in SQL
• Create a database
• Creating Cursors in SQL
• The Normal Forms
• Database Normalization
• Second Normal Form (2NF)
• Third Normal Form (1NF)
• Data Normalization

Ask Questions?    Discuss: SQL Add Column Int   View All Comments

Post your Comment

Your Name (*) :

Your Email :
Subject (*):
Your Comment (*):