Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 alter add column

Author  Topic 

sign_seventh
Yak Posting Veteran

66 Posts

Posted - 2009-02-12 : 01:03:02
Hi,
just want to know if it is possible to alter add column
to the position you want?
example table.
tbl_name
-----
field_id
field_name
field_address

is it possible to add [field_gender] in between [field_name]
and [field_address] by using alter add?..

i know it can be done manually. but i need it in purpose.
thanks

sridhar.dbe
Starting Member

34 Posts

Posted - 2009-02-12 : 01:15:55
it is s not possible to add column in specific position using alter command , for that purpose
you can add it using EM
Go to Top of Page
   

- Advertisement -