title: Create Temp Table based on Restore Filelistonly Results
body: <p>I am trying to create a temp table that contains the LogicalName, PhysicalName, Type and FileGroupName. I need this script to be SQL version Agnostic. </p>
  
  <pre><code>RESTORE FILELISTONLY FROM DISK = 'C:\BackupFile'
  </code></pre>
  
  <p>I can do this by creating the table first and then insert the information however as the results set of <code>RESTORE FILELISTONLY FROM DISK</code> changes per version i would need one script per SQL version. </p>
  
  <p>Im not sure if this is possible but any assistance would be very helpful</p>