|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Move a table from filegroup??Hi,
I created a table in a wrong filegroup. Is it possible to move it to another filegroup? If yes how? Do I need to drop the table and create it in the new filegroup or this can be done online (like oracle's alter table t move ....). Thanks in advance, Tarek recreate the index on the new filegroup, this will move the whole table
http://sqlservercode.blogspot.com/ Show quote "Tarek" wrote: > Hi, > I created a table in a wrong filegroup. Is it possible to move it to another > filegroup? If yes how? > Do I need to drop the table and create it in the new filegroup or this can > be done online (like oracle's alter table t move ....). > Thanks in advance, > > Tarek Tarek,
Just to qualify SQL's statment - ensure this is the clustered index that you are creating - a nonclustered index does not contain the data pages and therefore will not *move* the table. HTH Jerry Show quote "SQL" <S**@discussions.microsoft.com> wrote in message news:6AB9925F-D98D-4977-B66A-F15FD8407CA8@microsoft.com... > recreate the index on the new filegroup, this will move the whole table > > http://sqlservercode.blogspot.com/ > > "Tarek" wrote: > >> Hi, >> I created a table in a wrong filegroup. Is it possible to move it to >> another >> filegroup? If yes how? >> Do I need to drop the table and create it in the new filegroup or this >> can >> be done online (like oracle's alter table t move ....). >> Thanks in advance, >> >> Tarek Hi Tarek
Check out: http://tinyurl.com/78ovr John Show quote "Tarek" wrote: > Hi, > I created a table in a wrong filegroup. Is it possible to move it to another > filegroup? If yes how? > Do I need to drop the table and create it in the new filegroup or this can > be done online (like oracle's alter table t move ....). > Thanks in advance, > > Tarek  |
|||||||||||||||||||||||
Other interesting topics