As per my real-time experience, sometimes i might have needed to create the table structure same as other table. Mainly, i need only the
same table structure with all columns and with NO data . In these cases the simple and better query do the work....
SELECT *
INTO Emp_Backup
FROM EmployeeTable
WHERE 1=2
INTO Emp_Backup --> This part is to create new table named as 'Emp_Backup' with same structure of EmployeeTable
WHERE 1=2 --> this part is not to copy the data