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 |
|
andydev
Starting Member
5 Posts |
 Posted - 2002-05-27 : 02:21:42
|
| I need a the get the indexes from a table (not pkeys) and save them on a temp table, then drop the indexes, make some alter to the table, and then bring all the indexes back.I've made a script which does this, but for primary keys, now I need one for indexexRegardsAndy |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-05-27 : 05:57:54
|
| If you use sourcesafe to maintain your schema you would already have the indexes scripted and ready to run - and could easily maintain the drop script in the same way.In this case why not just script the index creates and drops using e-m or dmo and then just run them. you can run them manually or use osql.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Get all Indexes from a table