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 |
|
kiruthika
Yak Posting Veteran
67 Posts |
 Posted - 2008-09-09 : 07:15:47
|
| Dear All, sp_helptext is used to get the procedure text. What query can I use to get the index text? Where does the create index statement store? Thank You All...kiruthikahttp://www.ictned.eu |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-09-09 : 10:14:16
|
it's not stored anywhere, just like the DDL for tables. you can use SMO to get it though, if your app is managed. to get it from t-sql is not practical.
elsasoft.org |
 |
|
|
|
|
|
Get index text