>Hi,
>
>Is there a way (preferably with a visual tool) to insert a field in a SQL Server table so that it comes at a specific position amongst the fields?
>
>TIA,
>
Hi Alex,
You can do this with Enterprise Manger (EM).
- Right click on a table in EM and choose 'Design Table'
- Right click on the column you want to insert new column before and chose 'Inser Column'
- Fill the new column definition
--sb--