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