SQL Alter Table Add Multiple Columns
Alter Table Add Multiple Columns in SQL modifies the table and add
columns to the existing table.
Understand with Example
The Tutorial illustrates an example which demonstrate Alter Table Add
Multiple Columns. The SQL Query create a table 'Stu_Table' with table
attribute specified like field name, data type and etc using create
statement.
Create Table
SQL statement to create table:
create table Stu_Table(Stu_Id varchar(2), Stu_Name varchar(15), Stu_Class varchar(10));
|
Insert Data
SQL statement to insert data into table:
insert into Stu_Table values(1,'Komal',10);
insert into Stu_Table values(2,'Ajay',10);
insert into Stu_Table values(3,'Rakesh',10);
insert into Stu_Table values(4,'Bhanu',10);
insert into Stu_Table values(5,'Santosh',10);
insert into Stu_Table values(6,'Tanuj',10);
|
Describe Stu_Table
+-----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| Stu_Id | varchar(2) | YES | | | |
| Stu_Name | varchar(15) | YES | | | |
| Stu_Class | varchar(10) | YES | | | |
+-----------+-------------+------+-----+---------+-------+
|
Stu_Table
Records in the table:
+--------+----------+-----------+
| Stu_Id | Stu_Name | Stu_Class |
+--------+----------+-----------+
| 1 | Komal | 10 |
| 2 | Ajay | 10 |
| 3 | Rakesh | 10 |
| 4 | Bhanu | 10 |
| 5 | Santosh | 10 |
| 6 | Tanuj | 10 |
+--------+----------+-----------+
|
Add Multiple Columns Query
The Alter Table Query in SQL modifies the
existing table 'Stu_Table' and add a multiple columns to the
existing table. In this example, we add columns 'Stu_dob' and 'Stu_Address'
to the existing table 'Stu_Table'.
Alter Table Stu_Table add (Stu_dob date, Stu_Addreass varchar(20));
|
Describe Stu_Table
The Describe Stu_Table show you the new fields
added to the table'Stu_Table'.
+--------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| Stu_Id | varchar(2) | YES | | | |
| Stu_Name | varchar(15) | YES | | | |
| Stu_Class | varchar(10) | YES | | | |
| Stu_dob | date | YES | | | |
| Stu_Addreass | varchar(20) | YES | | | |
+--------------+-------------+------+-----+---------+-------+
|
Stu_Table
+--------+----------+-----------+---------+--------------+
| Stu_Id | Stu_Name | Stu_Class | Stu_dob | Stu_Addreass |
+--------+----------+-----------+---------+--------------+
| 1 | Komal | 10 | | |
| 2 | Ajay | 10 | | |
| 3 | Rakesh | 10 | | |
| 4 | Bhanu | 10 | | |
| 5 | Santosh | 10 | | |
| 6 | Tanuj | 10 | | |
+--------+----------+-----------+---------+--------------+
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
