Question Locked
sql server
0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
how to make copy of structure of table to another which is new one
Networks
by raovv06 Accepted solution
by tony hopkinson Accepted solution
Select Top 0 * Into MyNewTable
From MyOldTable
Will copy the Table structure, take out Top 0 if you want all the data.
Note no Primary key, index's or any other constraint will be copied.
If you want those, script the table to a file, rename as required and then execute.
This discussion is closed to new replies.
Sort by Trending