sqlserver 同义名的使用

USE [ccflow5]
GO
drop synonym ccuser
go
/****** Object:  Synonym [dbo].[ccuser]    Script Date: 11/12/2014 22:13:17 ******/
CREATE SYNONYM [dbo].[ccuser] FOR [AppBox].dbo.[Users]
GO

select * from ccuser;

注意红字提醒的dbo不能省略

 

posted on 2014-11-12 22:25  xihong  阅读(241)  评论(0编辑  收藏  举报

导航