[program-l] Re: Reordering fields in SQL 2000
- From: "David Lant" <david.lant1@xxxxxxxxxxxxxx>
- To: <program-l@xxxxxxxxxxxxx>
- Date: Fri, 23 Sep 2005 12:36:53 +0100
Hi,
To the best of my knowledge, there is no feature to reorder fields in an SQL
Server table. I've had to do this many times myself, and have always ended
up creating a new field in the location I want, copying the data from the
old to the new, and then deleting the old. Finally, renaming the new field
finishes the job.
I'm not even sure if there is a way to reorder fields using Enterprise
manager. I asked my sighted colleague a few days ago, and she said there
didn't seem to be an obvious way to do it there either.
Off the top of my head, I'm not even sure how you would script adding a new
field, in such a way that you specify its position among existing fields.
Logically there must be a way, otherwise how would Enterprise Manager allow
you to insert a new column at a specific location? But there you go. It
may just be well hidden.
All the best,
David
-----Original Message-----
From: program-l-bounce@xxxxxxxxxxxxx [mailto:program-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Charles Steyn
Sent: 23 September 2005 05:56
To: program-l@xxxxxxxxxxxxx
Subject: [program-l] Reordering fields in SQL 2000
Hi list,
I wonder if anybody can help me with this seemingly simple issue. I want to
reorder fields in a SQL Server 2000 table. I know you can use Enterprise
Manager to do this, but I find the visual tools hard to use and prefer to
script all my database changes. Is it possible to reorder fields using a
script or stored procedure?
Thanks and regards.
Charles Steyn
http://www.africon.com/MasterPages/Legalnotice/Legalnotice.htm
** To leave the list, click on the immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq
** To leave the list, click on the immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq
Other related posts:
