爲什麽在SQLServer2005中導出腳本的時候索引信息沒出來

Question

我在SQLServer 2005中使用導出腳本的方法導出表結構， 但是發現索引信息沒有 但是約束的信息是可以導出來的。 後來在management studio中的工具欄上的tools 的options中選擇scripting選項，在裏面將script indexes選項設置為TRUE，也還是不行，重啟下SQLServer也不行。 請問到底需要怎樣導出含有index的表結構？ 先謝謝大家了

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 1

How did you script table? I always get index in the script, didn't even change any option in ssms.

Answer 2

右鍵點擊到表上，選擇script table，然後選擇create，到新窗口中。

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 3

Just tried youe way, works for me. What's sql2k5 service pack level? Client tools have same service pack as server does?

Answer 4

工具--选项--生成脚本选项(大致名称是这个)--然后在里面把创建index 的部分设置为 true

Answer 5

在建立主键的时候，会自动为主键创建主索引
比如
CREATE TABLE [dbo].[BandWidth](
[BWB_ID] [numeric](10, 0) IDENTITY(1,1) NOT NULL,
 CONSTRAINT [PK_BANDWIDTH] PRIMARY KEY CLUSTERED
)

不知道你是不是这个意思？

---

Wenn ich dich hab’,gibt es nichts, was unerträglich ist.坚持不懈！My blog~~~

Answer 6

应该是这样设置：

  右键数据库-任务-生成脚本- 下一步   选中数据库   在"表/视图选项" 下方的编写索引脚本 栏选择"true "  下面继续 就ok 

Answer 7

Just tried youe way, works for me. What's sql2k5 service pack level? Client tools have same service pack as server does?



SQLServer 2005  3077

I just export the script on the local machine.

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 8

工具--选项--生成脚本选项(大致名称是这个)--然后在里面把创建index 的部分设置为 true

老大，我有這樣做。。但是還是不行。

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 9

应该是这样设置：

  右键数据库-任务-生成脚本- 下一步   选中数据库   在"表/视图选项" 下方的编写索引脚本 栏选择"true "  下面继续 就ok 


你這樣和在工具的選項中設置產生index是一樣的，還是無效。。

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 10

Just tried youe way, works for me. What's sql2k5 service pack level? Client tools have same service pack as server does?



SQLServer 2005  3077

I just export the script on the local machine.

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

I did it on sql2k5 4035 build, worked as expected.

Answer 11

Just tried youe way, works for me. What's sql2k5 service pack level? Client tools have same service pack as server does?



SQLServer 2005  3077

I just export the script on the local machine.

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

I did it on sql2k5 4035 build, worked as expected.

it works fine for me too.

---

Wenn ich dich hab’,gibt es nichts, was unerträglich ist.坚持不懈！My blog~~~

Answer 12

刚刚我测试了sql server 2008 与sql server 2005都能导出索引脚本

你的操作方法是不是有问题
  我放一段生成的脚本代码.

CREATE NONCLUSTERED INDEX [CostAD_ContainIndex] ON [dbo].[CostAd]
(
 [CostDate] ASC,
 [SiteId] ASC
)
INCLUDE ( [CostMoney]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

Answer 13

工具--选项--生成脚本选项(大致名称是这个)--然后在里面把创建index 的部分设置为 true

老大，我有這樣做。。但是還是不行。

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Double check your ssms version.

Answer 14

http://www.maillove.cn/NEWS.asp?id=179&infotype=2 各个版本的索引脚本导出