create synonym cimmgr.table_B for cimmgr.table_A; alter table cimmgr.table_a rename to table_c;

===========================================

===========================================
create table cimmgr.table_A
(
 user_id int,
 user_name varchar(20),
 user_age int
);

-- create synonym cimmgr.table_B for cimmgr.table_A;

create table cimmgr.table_A
(
 user_id int,
 user_name varchar(20),
 user_age int,
 sex varchar(2)
);

===========================================
-- alter table cimmgr.table_a rename to cimmgr.table_c;
-- rename table_a to table_c;
alter table cimmgr.table_a rename to table_c;
alter table cimmgr.table_c rename to table_a;

===========================================
insert into cimmgr.table_a values(3,'Lucy',18,'F');
select * from cimmgr.table_a;
select * from cimmgr.table_b;