You can't do that, SELECT INTO only copies structure and data types. To get everything, it'd be better to create the table first, anyway. You can go in to Object Explorer, right-click on table1, then choose SCRIPT TABLE AS ---> Create.Then just change then name to table2 before you run the script. You may need to go in to tools\options\ SQL Server Object Explorer\ Scripting to make sure that all the objects you want get scripted.