是否可以像在oracle中一样在SQL Server 2008中为索引名重新编制索引.

本文介绍了是否可以像在oracle中一样在SQL Server 2008中为索引名重新编制索引.的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

是否可以像在oracle中一样为SQL Server 2008中的索引名重新建立索引. 我们可以更改已经创建的表中的列顺序吗? 像: 表名到表名 Column1，column2，Column3，.... Column3，Column1，Column2，..... 如果可能，那么如何，如果不能，那么为什么不可能，请给出原因的解决方案 回复很快.紧急 提前致谢.

is it possible to reindexing column names in SQL Server 2008 as we do in oracle. can we alter columns order in already created table. like: Table_Name to Table_Name Column1,column2,Column3,.... Column3,Column1,Column2,........ if is it possible then how and if not then why is it not possible, plz give solution with reason Reply Fast. Its urgent Thanks in Advance.

推荐答案

是的.有可能. 转到表格设计. 然后选择要移动的列. 拖放到新位置. Yeah. Its possible. Go to table design. Then select the column you want to move. Drag and drop to your new place.

尽管可以在Management Studio中更改列的顺序，但无需这样做.从SQL的角度来看，列的顺序无关紧要.那么，为什么要尝试这样做呢?也许是因为其他问题? Although it''s possible to change the order of columns in Management Studio, there should be no need to do this. From SQL point of view the order of columns doesn''t matter. So why are you trying to do this? Perhaps because of some other problem?