SQL & PL/SQL

Hi Everyone,
i have two tables AB_ENTITY,R_COMPANY initially.

AB_ENTITY table contains (AB_ENTITY_id, AB_ENTITY_name) columns.
R_COMPANY table contains(R_COMPANY_id,R_COMPANY_name) columns.

my requirement is make R_COMPANY as a synonym to AB_ENTITY table. so,

i will drop R_COMPANY table and make it as a synonym to AB_ENTITY table , for this i created

create public synonym R_COMPANY for AB_ENTITY;


now R_COMPANY synonym contains (AB_ENTITY_id, AB_ENTITY_name) columns. but i want to rename AB_ENTITY_id as R_COMPANY_id.


because this column i am using for other table foreign key constraints .


so, please advice me .