Sql Server 创建同义词

建立其他服务器 的同义词脚本

服务器需要先建立好远程连接

CREATE SYNONYM [ICSerial] FOR [xx.xx.xx].[AIS20210705170505].[dbo].[ICSerial]

修改

USE [name]
GO

/****** Object:  Synonym [dbo].[ICBOM]    Script Date: 2021/12/2 13:46:15 ******/
DROP SYNONYM [dbo].[ICBOM]
GO

/****** Object:  Synonym [dbo].[ICBOM]    Script Date: 2021/12/2 13:46:16 ******/
CREATE SYNONYM [dbo].[ICBOM] FOR [xx.xx.xx].[AIS20210705170505].[dbo].[ICBOM]
GO