You are here: Re: add a column specified location in Table.. « MsSQL Server « IT news, forums, messages
Re: add a column specified location in Table..

Posted by Jens on 03/20/06 09:26

Hi,

there is no need to put the columns in a table in a correct order,
because you can sort them via the select or a view as you want to.
There is further no way to put a column "in between" because there is
no need to. If you really want to do this (but I would suggest you not
to do this) you have to recreate the table with the new column in
between and copy alle the data from the old table to the new table.


HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация