Using INTO we can copy..
SELECT TOP 0 * INTO New_Table_Name From Old_Table_Name
The Above query will come only the structure for the table..
If U want to copy with the data then remove the "Top 0 "..
SELECT * INTO New_Table_Name FROM Old_Table_Name
Using INTO we can copy..
SELECT TOP 0 * INTO New_Table_Name From Old_Table_Name
The Above query will come only the structure for the table..
If U want to copy with the data then remove the "Top 0 "..
SELECT * INTO New_Table_Name FROM Old_Table_Name