synonyms in SQL server 2000

12 May 2005 3:22 PM

Mangesh Deshpande

Hi

I am using linked servers a lot in application. I want to create small
meaningfull table name for all these tables. Is there a concept called
synonym like in oracle to create small names for these?

Example:
select * from [sql3].master.dbo.xx;
create synonym xx_sql3 for [sql3].master.dbo.xx; --??
select * from xx_sql3;

Tks
Mangesh

12 May 2005 3:29 PM

Anith Sen

There are no synonyms in SQL Server. For comparable functionality, use a
view instead.

--
Anith

12 May 2005 5:11 PM

Tibor Karaszi

.... but there will be in 2005. :-)

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

Show quote

"Anith Sen" <an***@bizdatasolutions.com> wrote in message
news:%23UWRgewVFHA.2328@TK2MSFTNGP10.phx.gbl...
> There are no synonyms in SQL Server. For comparable functionality, use a view instead.
>
> --
> Anith
>

12 May 2005 6:52 PM

Hari Prasad

Hi Tibor,

Thank you, That is a great news. Synonyms will help us in a great fashion.

Thanks
Hari
SQL SERVER MVP

Show quote

"Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in
message news:uCnfrWxVFHA.3488@tk2msftngp13.phx.gbl...
> ... but there will be in 2005. :-)
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
>
> "Anith Sen" <an***@bizdatasolutions.com> wrote in message
> news:%23UWRgewVFHA.2328@TK2MSFTNGP10.phx.gbl...
>> There are no synonyms in SQL Server. For comparable functionality, use a
>> view instead.
>>
>> --
>> Anith
>>
>
>