SQL Add Column Position

SQL Add Column Position is used to add the column at the specific position. The Alter statement copy the structure of existed table and make a modify a table on the basis of specified Query.

Understand with Example

The Tutorial illustrates an example from SQL Add Column Position to the existing 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 modify table name 'table_name' and add a column at the specific position. The first column specify the position of the column to be come first in table followed by a after column in a table. The Syntax is given as : 

ALTER TABLE table_name
ADD column_name column-definition [ FIRST | AFTER col_name ]

SQL Add Colum Query

The SQL Add Column Query add a Stu_Name column followed by Stu_Name in the Table Stu_Table.

Alter Table Stu_Table add Stu_Class int(10) AFTER Stu_Name

View data  Stu_Table

Related Tags for SQL Add Column Position:
sql,  c,  query,  table,  io,  struct,  copy,  make,  sed,  column,  structure,  state,  position,  tab,  if,  ie,  add,  statement,  to,  modify,  pos,  ci,  e,  it,  alter,  use,  pe,  mod,  as,  sta,  m,  nt,  tr,  os,  osi,  dd,  osi,  os,  ad,  spec,  em,  alt,  me,  modi,  umn,  s,  sp,  col,  at,  k,  is,  and,  cop,  stat,  str,  specific,  xi,  s,  s,  th,  st,  ab,  abl,  asis,  exi,  lum,  nd,  on,  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 Position   View All Comments

Post your Comment

Your Name (*) :

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