Renaming

sp_rename

--===============[sp_rename==================================================================

-- Renaming Table

-- System procedure sp_rename modifies the name of an existing table

 sp_rename employee, customer

 SELECT * FROM customer