Re: synonims

From: Andy Svendsen (andymcdba1_at_NOMORESPAM.yahoo.com)
Date: 01/22/04 

Date: Thu, 22 Jan 2004 10:02:42 -0500

Wow...I have had little Oracle experience, so that was quite a discovery.
The sad truth is that closest you can find to that functionality is are
views. However, views are hardly global variables, and they don't cover
everything unfortunately.

You don't have to specify a table's owner name to reference it in MSSQL,
transact-SQL lets you be rather lazy, probably a lot more so that Oracle's
SQL.

Still, no real synonym equivalent in MSSQL 4.2./6.5/7/2000 that I know of.
Who knows...maybe Yukon? : ) 

-- 
*******************************************************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
*******************************************************************
"ana maria" <anonymous@discussions.microsoft.com> wrote in message
news:5C97773A-AEC3-43AF-8CEF-06D8BF3FE649@microsoft.com...
> Can I create synonims in sql server as I can do it in oracle???