SQL Server 2008 R2 将列添加到特定位置

2021-09-10 00:00:00 tsql sql-server-2008 sql-server

我正在使用 SQL Server 2008 R2，我希望将新列添加到表中列顺序中的特定位置，而不是最后.我希望避免重新创建表.如何在不重新创建表格的情况下执行此操作?

I am using SQL Server 2008 R2 and I wish to add a new column into a specific spot in the column order in a table and not at the end. I wish to avoid having to recreate the table. How do I do this without recreating the table?

即

Table: Bob
==========
   Col1
   Col2

添加新列.

Table: Bob
==========
   Col1
   NewCol
   Col2

推荐答案

你不能.列始终添加在列列表的末尾.更改顺序的唯一方法是从头开始重新创建表.

You cannot. Column are always added at the end of the column list. The only way to change the order is to recreate the table from scratch.

话虽如此，列的实际物理顺序或列定义的逻辑顺序对您来说永远无关紧要.如果您对列顺序有依赖性，则您的代码已损坏.如果您希望从列顺序中获得性能提升，那这些都是误区.

That being said, it should never ever matter to you what is the actual physical order of the columns, nor the logical order of column definitions. If you have dependencies on column order, your code is broken. If you expect performance gains from column order, those are myths.

相关文章