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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-19 : 09:39:27
|
| Ehsan writes "Is it possible to change the filegroup of existing table?Regards,EhsanF." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-06-19 : 09:40:34
|
| Not directly, but if you create that table's clustered index on the new filegroup it will move the data over to it.Look in Books Online under "ALTER TABLE" and "CREATE INDEX" for more details. |
 |
|
|
|
|
|
Changing filegroups