I am trying to find out what the QUERY in MSSQL is to make an exact copy of a table under a different name but for all of it's columns to be transferred as well as anything else that it has. Not including the rows. Keep in mind Listings2 has no columns created in it, so it would have Listing1's columns copied over to it. So Listings1 - TableName Name Email State - Columns Copied to another table named Listings2 Listings2 - Table Name Name Email State - Columns
INSERT INTO new_table SELECT * FROM old_table; You may need to specify column names... INSERT INTO new_table (column_names) SELECT (column_names) FROM old_table;