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

2 replies

by tony hopkinson

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.