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