达梦创建同义词

1.   创建同义词

CREATE OR REPLACE SYNONYM "username1"."table_name" FOR "username2"."table_name";

2.  批量创建同义词

        生成批量脚本

select 'CREATE OR REPLACE SYNONYM "username1"."'||TABLE_NAME||'" FOR "username2"."'||TABLE_NAME||'";'
from user_tab_comments where table_type='TABLE';