Select * from Customer


Select * from sys.Tables


Create trigger tr_CustomerDelete on Customer
For delete
--this trigger will execute after the delete
AS
--check to see if our temp table exists
if not exists 
	(Select "Name" From sys.Tables
		Where "Name"='CustDelete')
Begin
--if not create it
Create Table CustDelete
(
  CustID int,
  CustLastName varchar(30),
  CustFirstName varchar(25),
  CustAddress varchar(100),
  CustCity varchar(50),
  CustState char(2),
  CustzipCode char(11),
  CustPhone char(10)
)

End

--insert the deleted values into the temp table
Insert into CustDelete (CustID, custLastName, CustfirstName,
			CustAddress, CustCity, CustState, CustZipCode, CustPhone)
	Select CustID, CustLastName, custFirstname, CustAddress, CustCity,
		CustState, CustZipcode, custphone From Deleted)



Delete from Customer
Where CustID=17

Select * from CustDelete