Synonyms 1

Question

Post reply

Synonyms 1

Steve Jones - SSC Editor

SSC Guru

Points: 736210
More actions
September 6, 2014 at 11:21 am

#74500

Comments posted to this topic are about the item Synonyms 1
September 8, 2014 at 3:26 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 36 total)

You must be logged in to reply to this topic. Login to reply

Hany Helmy SSChampion Points: 13921 More actions · Answer 1

In the question:

CREATE SYNONYM Emp

but in the explanation:

SELECT * FROM emp2

From where this emp2 came?!

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Hany Helmy SSChampion Points: 13921 More actions · Answer 2

But anyway it`s good question although I am using table aliases in the code structure more than synonyms.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

Interesting question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 4

...but it works for Joe in HR (that's his default schema);-)

😎

Steve Jones - SSC Editor SSC Guru Points: 736210 More actions · Answer 5

Hany Helmy (9/7/2014)
In the question:
CREATE SYNONYM Emp
but in the explanation:
SELECT * FROM emp2
From where this emp2 came?!

a typo. It's fixed

Vimal Lohani SSCommitted Points: 1650 More actions · Answer 6

good question.

Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature

Hany Helmy SSChampion Points: 13921 More actions · Answer 7

Steve Jones - SSC Editor (9/7/2014)
Hany Helmy (9/7/2014)
In the question:
CREATE SYNONYM Emp
but in the explanation:
SELECT * FROM emp2
From where this emp2 came?!
a typo. It's fixed

Thx.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

vineet_dubey1975 SSCrazy Points: 2306 More actions · Answer 8

in sql server 2012 I am able to create the synoname also I am able to select the rows from the table.

so this means this is only true in the older version of the sql server.

Thanks

Vineet

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 9

Never gave it a second thought but figured deferred name resolution should be in play during synonym creation. Thanks for the question.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

Carlo Romagnano SSC-Insane Points: 22669 More actions · Answer 10

Eirikur Eiriksson (9/7/2014)
...but it works for Joe in HR (that's his default schema);-)
😎

That's true!

Umer Akram SSC-Insane Points: 22209 More actions · Answer 11

Umer Akram

SSC-Insane

Points: 22209

September 8, 2014 at 1:23 am

#1743784

interesting question. Thanks for share

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 12

vineet_dubey1975 (9/8/2014)
in sql server 2012 I am able to create the synoname also I am able to select the rows from the table.
so this means this is only true in the older version of the sql server.
Thanks
Vineet

USE LOCALWORK

GO

CREATE SCHEMA HumanResource

GO

CREATE TABLE HumanResource.Employee

(

EmpID INT IDENTITY,

EmpName Varchar(10)

);

GO

CREATE SYNONYM Emp FOR Employee;

SELECT * FROM EMP;

Just to confirm, if the above way you tested, then no, it still gives you the error below error in Sql 2012 dev edition (which currently I am using)

Msg 5313, Level 16, State 1, Line 1

Synonym 'emp' refers to an invalid object.

-//edit- Post your code, may be it is something different or I must have understood it wrong.

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 13

Thank you, SJ, interesting one.

(I had selected 2nd choice, but still I wrote the code to test my analysis... I succeed :-). To be honest, never tried this explicitly.)

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.