title: Copy table without data
body: <p>I am creating a temp table partially based on a structure from another (non temp) table. I need just the structure, not the data. In my research I found 2 SELECT statements that does what I need:</p>
  
  <pre><code>SELECT ID, Field1 FROM Table1 (NOLOCK) WHERE 0=1
  </code></pre>
  
  <p>and </p>
  
  <pre><code>SELECT TOP (0) ID, Field1 FROM Table1 (NOLOCK)
  </code></pre>
  
  <p>The performance difference is probably negligible, but I wanted to know which SELECT is more efficient?</p>
  
  <p>Thanks</p>
  
  <p>EDIT 1: I am using Microsoft SQL Server 2005 - 9.00.5057.00 (X64) 64-bit on Windows NT 6.1 (Build 7601: Service Pack 1)</p>
  
  <p>EDIT 2: Execution plan for both statements looks exactly the same so I am guessing if there is difference in performance, it is negligible.</p>