How to copy ( duplicate ) a table in ms sql ?

For creating exact copy of a table you can use this command:

SELECT * INTO NewTable
FROM OldTable
Advertisements