带数据连接的同意词.sql

来自「地磅采集过磅系统」· SQL 代码 · 共 27 行

-- Drop the existing synonym 
drop synonym IE_CON_CRG_WEB;
-- Create the new synonym 
create synonym IE_CON_CRG_WEB
  for JZWEB.IE_CON_CRG_WEB@IBM_JZCON_SUN;

-- Drop the existing synonym 
drop synonym IE_CON_CONR_WEB;
-- Create the new synonym 
create synonym IE_CON_CONR_WEB
  for JZWEB.IE_CON_CONR_WEB@IBM_JZCON_SUN;

-- Drop the existing synonym 
drop synonym CONTRACT_IE_DOC_WEB;
-- Create the new synonym 
create synonym CONTRACT_IE_DOC_WEB
  for JZWEB.CONTRACT_IE_DOC_WEB@IBM_JZCON_SUN;


-----------NEW CREATE
CREATE SYNONYM CONTRACT_IE_DOC_WEB FOR JZWEB.CONTRACT_IE_DOC_WEB; 


CREATE SYNONYM IE_CON_CNTR_WEB FOR JZWEB.IE_CON_CNTR_WEB; 
CREATE SYNONYM IE_CON_CRG_WEB FOR JZWEB.IE_CON_CRG_WEB;