copy the structure of table without copying the Data
how can copy the structure of table without copying the Data using c#.net & sql-server2000 or 2005
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jaish MathewsPosted Jul 26, 2010, 2:30 PM
One easy way is below query
SELECT *
INTO NewTableName
FROM SourceTable
WHERE 1 = 2
But this won't coy any constraints to new table