Can a table be moved to different filegroup?



Can a table be moved to different filegroup?..

Answer / Anjali Singh

Yes, a table in SQL Server can be moved to a different filegroup using the ALTER TABLE command.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How to delete a login name in ms sql server?

1 Answers  


What is the role that is required for killing a process What is the role that is required for creating a linked server

1 Answers   CarrizalSoft Technologies, IBM,


Tell me what do we need queues in sql service broker?

1 Answers  


How you can change a cross join into an inner join?

1 Answers  


How do you find value of first column before inserting value into the second column in the same table for checking that second column must have different value than first column.

2 Answers   L&T,


Can an automatic recovery be initiated by a user?

1 Answers  


What is the difference between a Application Server and a Database

3 Answers   Oracle,


how you can get the list of largest tables in a database? : Sql server administration

1 Answers  


What do you mean by an execution plan? How would you view it?

1 Answers  


Why Master database is required?

1 Answers   Abacus,


What is hot add cpu in sql server 2008?

1 Answers  


What is an execution plan? When would you use it?

1 Answers  


Categories