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 |
|
ProEdge
Yak Posting Veteran
64 Posts |
 Posted - 2007-05-24 : 12:38:30
|
| Does anyone know the syntax to alter a table's current index? For instance, I might want to change the fillfactor. Or do you have to drop and re-create it? Thanks |
|
|
ProEdge
Yak Posting Veteran
64 Posts |
Posted - 2007-05-24 : 12:50:06
|
| Never mind. I found the syntax through SQL Server's GUI. I just had it generate the sql for me. It looks like you do have to drop the constraint first. Thanks |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-24 : 13:35:31
|
| "Or do you have to drop and re-create it?"Yup, as you've found out, that's the drill.Kristen |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-05-25 : 04:27:00
|
| also note that the fillfactor only applies to the existing data pages and not for the future data pages._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-25 : 06:58:05
|
| "not for the future data pages"... until you Reindex.Kristen |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-05-25 : 07:19:07
|
welll yes.. but that's already existing data  _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
Alter Table Index