Finding FileGroup from table name

• chuckd

  SSC-Addicted

  Points: 471

  More actions

  April 11, 2002 at 9:55 am

  #357513

  I'm trying to come up with a simple T-SQL statement that will return the filegroup that a particular table belongs to. I can't offhand see where sysobjects references anything I can join other tables with (like sysfiles) to determine this.

  This has to be a simple thing! Thanks.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  April 11, 2002 at 11:34 am

  #427061

  This will get it but you have to have the Table ID which I have scripted to get then get group. Note: only shows Table filegroup not Text Filegroup.

  DECLARE @id INT

  SELECT @id = OBJECT_ID('tbl_name_here')

  EXEC sp_objectfilegroup @id

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)