Database Scripts

  If you wanna find on which Data File your SQL Server Table is on, use the following query by providing the table name you are looking for: