Alias name for database

Question

I have a scenario to use Alias name to access database from SP, and I would like to know if there is any method to achieve this in SQL Server.

Since Linked Servers only allows Server objects and SYNONYM only allow object inside the database.

http://stackoverflow.com/questions/444139/how-to-create-sql-synonym-or-alias-for-database-name — Nagaraj S, Mar 04 '14 at 06:34
[Using Synonyms (Database Engine)](http://msdn.microsoft.com/en-us/library/ms187552%28v=sql.100%29.aspx) — Satinder singh, Mar 04 '14 at 06:36
As I said , my final query look like select * from MyAlias.dbo.tablename , and i am not using any front end application, so i may not able to control my connections. — Samith C Valsalan, Mar 04 '14 at 06:40
Take a look at this [**link**](http://www.sqlservercentral.com/Forums/Topic654478-146-1.aspx) — Vignesh Kumar A, Mar 04 '14 at 06:43
There's no facility to allow alternate names to be used at the database level. — Damien_The_Unbeliever, Mar 04 '14 at 07:13
No. I think you should explain what you are trying to do. Maybe there is a better solution — Nick.Mc, May 09 '18 at 12:32

score 0 · Answer 1 · answered May 09 '18 at 13:12

0

You can create a SYNONYM which includes the database name of the linked server ...

CREATE SYNONYM LinkedTableA
FOR DEVLINK.testdata.dbo.customer

and can then query ...

SELECT * FROM dbo.LinkedTableA

answered May 09 '18 at 13:12

SteveC

1 Answers1