如何更改 SQL Server 2008 中现有表的列顺序 [英] How To change the column order of An Existing Table in 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.

这篇关于如何更改 SQL Server 2008 中现有表的列顺序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！