Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
okalosha
Starting Member
4 Posts |
 Posted - 2005-10-27 : 21:35:27
|
| Hi -I could not find an SQL script, which would generate index creation DDL for a specific table/index. Query Analyzer does it, but I need to do it programmatically. Does anyone have a working script?Thank you. |
|
|
activecrypt
Posting Yak Master
165 Posts |
Posted - 2005-10-28 : 03:06:25
|
Hi,didnt get you onthis !if INDEX CAN BE GENERATED FROM EM then it can be generated by SCRIPT To , have you read BOL for * CREATE INDEX * .  HTH-----------------------------------------------------------MSSQL Server encryption software http://www.activecrypt.com |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-10-28 : 03:32:53
|
| This is the forum to contribute workable scriptsHereafter post your questions at relevent forums like "Developer Forum"MadhivananFailing to plan is Planning to fail |
|
|
|
okalosha
Starting Member
4 Posts |
Posted - 2005-10-28 : 12:59:53
|
| I am moving this topic to "Developer" folder |
|
|
|
|
|
|
Creation script for an index