Transact-SQL Backup And Delete (Drop) A Table Examples

Tool : Microsoft SQL Server Management Studio (SSMS)

Transact-SQL Create Database And Create Table Examples

Transact-SQL Insert Data Into Table Examples

Transact-SQL Retrieve Data From A Table Examples

Transact-SQL Update And Delete Data from A Table Examples

Backup A Table Into A New Table

/* Backup a table into a new table */

Use [SampleDB]
Go
Select * 
Into [Employees_Backup]
From [Employees]

Delete (Drop) The Table [Employees_Backup]

/* Delete (drop) the table [Employees_Backup] */

Use [SampleDB]
Go
Drop Table [Employees_Backup]