How to take backup of table in sql and How to take backup of table without data in sql

 Select * into NewKBTable from tblstudent

Select * from NewKBTable



Select * into tblwithbackup from tblstudent where 1 = 2

Select * from tblwithbackup

--2nd Method

Select top 0 * into tblwithbackup2 from tblstudent


0 Comments