Table to Datafile mapping

• shahgols

  SSCrazy Eights

  Points: 9874

  More actions

  May 2, 2003 at 6:20 pm

  #63287

  Is there a way to find out which datafile each table resides on? Thanks in advance for your help.

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  May 2, 2003 at 6:59 pm

  #456089

  SELECT sf.groupid AS GroupID, substring(sf.groupname,1,30) AS FilegroupName,

  substring(so.name,1,30) AS ObjectName

  FROM sysobjects so

  INNER JOIN sysindexes si ON so.id = si.id

  INNER JOIN sysfilegroups sf ON si.groupid = sf.groupid

  WHERE si.indid = 0 and so.xtype = 'U'

  ORDER BY sf.groupname, so.ObjectName