By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,265 Members | 1,333 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,265 IT Pros & Developers. It's quick & easy.

Sql Server Alter statement

100+
P: 111
Hi all,

If I want to add more than one table to an existing table. What is the syntax. Can any one please help me finding this....

For One table:
--------------------
alter table tbl_Name
add column col_name varchar(200);

More than One?.

Thanks & Regards
Bharath Reddy VasiReddy
Oct 13 '08 #1
Share this Question
Share on Google+
1 Reply


100+
P: 111
hi all here i got a nice article on alter statements:

To add multiple columns to an existing table, the ALTER TABLE syntax is:

ALTER TABLE table_name
ADD ( column_1 column-definition,
column_2 column-definition,
...
column_n column_definition );

For example:

ALTER TABLE supplier
ADD ( supplier_name varchar2(50),
city varchar2(45) );

This will add two columns (supplier_name and city) to the supplier table.

For More infromation Please visit this page:
http://www.techonthenet.com/sql/tables/alter_table.php

Enjoy Coding........


Bharath Reddy VasiReddy
Oct 13 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.