Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Sql SQL Alter Table Add Multiple Columns

Related Tutorials


 
 

Share on Google+Share on Google+

SQL Alter Table Add Multiple Columns

Advertisement
Alter Table Add Multiple Columns in SQL modifies the table and add columns to the existing table.

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        |         |              |
+--------+----------+-----------+---------+--------------+
Advertisement

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: May 27, 2009

Related Tutorials

Discuss: SQL Alter Table Add Multiple Columns   View All Comments

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:5
Franky
August 17, 2011
ADD multiple columns

Alter Table Stu_Table add (Stu_dob date, Stu_Addreass varchar(20)); is wrong on SQL server 2005, you have to use: Alter Table Stu_Table add Stu_dob date, Stu_Addreass varchar(20);
BAIG MOHD IRFAN
October 3, 2011
sql and orecal system

i want teching all sql and orecal.
dhananjay
January 11, 2013
facing some error messages

facing some error messages in altering my table's data
philani
October 22, 2012
mysql

How to add a column in to a table
surabhi chugh
April 11, 2013
query

how to insert values in an altered table...like in the above example table stu_table has been altered...now how will we insert values in the column stu_job and stu_address
DMCA.com