copy whole table structure from one table to another in sql server
<p>I wrote a query to copy the table's structure from one table to another table in sql server.</p>

<pre><code>SELECT * INTO Database.Schema.TableNew 
FROM Database.Schema.OldTable 
WHERE 1=2
</code></pre>

<p>But through that query, i am able to copy table's structure, but it is not copying checksum's function value.</p>