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
--> This part is to create new table named as 'Emp_Backup' with same structure of EmployeeTableWHERE 1=2
--> this part is not to copy the data