if you want Clone a table from existing table date you can use following Syntax for SQL select * into EmpClone from [dbo].Emp ; select * from EmpClone;