Using “Select ColumnNames into” syntax we can create copy of existing recordset. Copy includes structure and data both.
Select * into
NewCustomerTable from CustomerTable
For Shallow copy we can do something like this.
Select top 0 * into
NewCustomerTable from CustomerTable.
It will just create a new table whose structure will be similar to CustomerTable but records will not get copied.