InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 07:04:04 GMT20http://www.sqlservercentral.com/Forums/Topic1409892-391-1.aspx[code="sql"]SELECT o.[name] AS ObjectName, o.[type] AS ObjectType, s.[name] AS SchemaName, f.[name] AS [Filename], i.[name] AS PrimaryKey, i.[index_id] AS IndexIDFROM sys.indexes iINNER JOIN sys.filegroups f ON i.data_space_id = f.data_space_idINNER JOIN sys.all_objects o ON i.[object_id] = o.[object_id]INNER JOIN sys.schemas s ON s.[schema_id] = o.[schema_id]order by s.[name], o.[name][/code]Tue, 22 Jan 2013 08:10:31 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1409892-391-1.aspxi have this saved, whcih shows all tables/the filegroup they belong to:[code]SELECT objz.[name], objz.[type], idxz.[name], idxz.[index_id], CASE idxz.[index_id] WHEN 0 THEN 'HEAP' WHEN 1 THEN 'CLUSTERED' ELSE 'NON-CLUSTERED' END AS index_type, filz.[name] FROM sys.indexes idxz INNER JOIN sys.filegroups filz ON idxz.data_space_id = filz.data_space_id INNER JOIN sys.all_objects objz ON idxz.[object_id] = objz.[object_id] WHERE idxz.data_space_id = filz.data_space_id AND objz.type_desc IN( 'USER_TABLE') -- User Created Tables[/code]Tue, 22 Jan 2013 08:10:19 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1409892-391-1.aspxDifferent file groupsTue, 22 Jan 2013 08:01:35 GMTrajkiran.panchagirihttp://www.sqlservercentral.com/Forums/Topic1409892-391-1.aspxA table doesnt exist on a data file, it exists on a file group.Are the MDF and NDF in different file groups or are they both in the primary filegroup?Tue, 22 Jan 2013 04:06:55 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1409892-391-1.aspxHi Friends, Let us assume am having 2 data files one mdf and one ndf. I have stopped the autogrowth of mdf. Is there a way to find in which data file the particular table exists.Thanks in advance.Tue, 22 Jan 2013 03:27:37 GMTrajkiran.panchagiri