Sync two table column names

Question

Create a Stored Procedure for Sync two Column names(Field names) of those tables
For Example I have two tables(A and B) .
if i Change a column in table A and Executed that Stored procedure then it will B table Column name change.

Answer 1

Check this procedure:

create or alter procedure SyncAB
as
begin
    declare @oldname varchar(max) = 
        (
            select [name]
            from sys.columns
            where object_id = object_id('B')
            except 
            select [name]
            from sys.columns
            where object_id = object_id('A')
        )

    declare @newname varchar(max) = 
        (
            select [name]
            from sys.columns
            where object_id = object_id('A')
            except 
            select [name]
            from sys.columns
            where object_id = object_id('B')
        )

    declare @sql varchar(max) = concat('sp_rename ''B.', quotename(replace(@oldname, '''', '''''')), ''', ', quotename(@newname, ''''), ', ''COLUMN''')

    --print @sql

    exec (@sql)
end