Changing order of fields in table

Topic

New Reply

We have an SQL database connected to Access via an ODBC link. When viewing the design of a table in SQL Server 2005 Management Studio or Access 2007, the fields are listed in the order in which they were created. Presumably the actual order of the fields is not important to applications that use the database, and they can be presented in a different order using queries, forms and reports. However, is it possible to change the actual order in which fields are listed when viewing the design of a table, for convenience and clarity, without recreating a new table and transferring the data into it?

Reply | Quote

Replies

In Access you can drag & drop the fields in Design view. I don’t know about doing this in a linked DB.

RG

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

You can rearrange fields in SQL Server 2005 and 2008 by clicking on a field (called column in SQL Server) and dragging it up or down. However you are changing the design when you do that, as you have to save it for it to be permanent. And after you do that in SQL Server, then will need to relink the table so that Access sees them in the new order. As an alternative, you can create a view in SQL Server (much like a query in Access), and then link to the view from Access and that lets you arrange the fields in any order that you wish. Note however that the order of the fields has no significance in either Access or SQL Server – the only reason for changing it might be to provide clearer documentation.

Reply | Quote

Thanks for your replies.

Reply | Quote