[program-l] Reordering fields in SQL 2000

  • From: "Charles Steyn" <CharlesS@xxxxxxxxxxxxx>
  • To: <program-l@xxxxxxxxxxxxx>
  • Date: Fri, 23 Sep 2005 06:55:31 +0200

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

Other related posts: