• 1.to modify Default FG from primary to new FG, I would create nw FG, add new .ndf file, use ALTER DATABASE and make it default

    2.to delete the new FG, make another FG as DEFAULT, would move all the objects in that FG to other FG, delete the .ndf file

    If the tables hav no indexes*, then i should create tables in the New FG and move the data to the new table (in new FG) and delete OLD table in Old FG. Is this correct?

    * Tables would be having clustered indexes, i want to know, in case threre are no indexes