如何更改 SQL Server 2008 中现有表的列顺序
问题描述:
我遇到需要更改列顺序/为 SQL Server 2008 中的现有表添加新列的情况.
I have situation where I need to change the order of the columns/adding new columns for existing Table in SQL Server 2008.
现有列
MemberName
MemberAddress
Member_ID(pk)
我想要这个订单
Member_ID(pk)
MemberName
MemberAddress
答
我得到了同样的答案,继续SQL Server → Tools → Options → Designers → Table and Database Designers
并取消选择阻止保存需要重新创建表的更改
I got the answer for the same ,
Go on SQL Server → Tools → Options → Designers → Table and Database Designers
and unselect Prevent saving changes that require table re-creation
2- 打开表格设计视图,上下滚动列并保存更改.
2- Open table design view and that scroll your column up and down and save your changes.