MSSQL Quick Copy Table / MSSQL Server / By Tim van Kooten Niekerk Quickly duplicate a table with the following query. SELECT * INTO newtable FROM table