Generate relationship for renamed table

A table can be renamed by using a system procedure in SQLServer/AzureSQL called sp_rename. In the following sample procedure, a table gets renamed from EmployeeSales to FactEmployeeSales followed by INSERT from the renamed table:

CREATE TABLE dbo.EmployeeSales
(
    DataSource varchar(20) NOT NULL,
    BusinessEntityID varchar(11) NOT NULL,
    LastName varchar(40) NOT NULL,
    SalesDollars money NOT NULL
);

CREATE PROCEDURE dbo.uspUpdateEmployeeSales
AS
    SET NOCOUNT ON;

    EXEC sp_rename 'dbo.EmployeeSales', 'FactEmployeeSales';

    INSERT INTO dbo.AggSales
    SELECT LastName, SUM(SalesDollars) AS [Agg Sales]
    FROM dbo.FactEmployeeSales
    GROUP BY LastName;

Result:

With Oracle, ALTER TABLE table_name RENAME [TO|AS] new_table_name is used to rename a table.

Result: