SQL Add a column in a specific position in a tableSQL 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
| Stu_Id | Stu_Name |
| 1 | Komal |
| 2 | Ajay |
| 3 | Rakesh |
| 4 | Bhanu |
| 5 | Santosh |
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
| Stu_Id | Stu_Name | Stu_Class |
| 1 | Komal | NULL |
| 2 | Ajay | NULL |
| 3 | Rakesh | NULL |
| 4 | Bhanu | NULL |
| 5 | Santosh | NULL |