创建表:
CREATE TABLE [aaa].[Log_ZHXT_ShippingBusiness](
[SelfIncreasingID] [bigint] NOT NULL,
[DealUID] [bigint] NULL,
[SendingContext] [nvarchar](1000) NULL,
[ReceivingContext] [nvarchar](1000) NULL,
[InterfaceClassification] [nvarchar](20) NULL,
[SendingTime] [datetime] NULL,
[ApprovalStatus] [char](1) NULL,
[ChargeIDs] [nvarchar](255) NULL
)
GO
创建完成后查询表的内容:
select * from [Log_ZHXT_ShippingBusiness]
执行后发现报错:
然后将该表在dbo架构下重命名:
CREATE SYNONYM [dbo].[Log_ZHXT_ShippingBusiness] FOR [cnooc].[Log_ZHXT_ShippingBusiness]
然后再查询就不报错了.
注:select时不添加架构前缀,默认select dbo架构下的表。