Home » SQL & PL/SQL » SQL & PL/SQL » Synonym - Which table it points to
Synonym - Which table it points to [message #418553] Mon, 17 August 2009 05:06 Go to next message
elaiyavel
Messages: 114
Registered: April 2008
Senior Member
Hi,

I have been given a synonym name, and how will i able to find out the base table which the synonym is referring to.

Thanks,
Elaiyavel.
Re: Synonym - Which table it points to [message #418554 is a reply to message #418553] Mon, 17 August 2009 05:10 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Look at USER / ALL / DBA_SYNONYMS
Re: Synonym - Which table it points to [message #418555 is a reply to message #418553] Mon, 17 August 2009 05:11 Go to previous message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
user_synonyms
Previous Topic: regarding some topics in oracel
Next Topic: Related Tables
Goto Forum:
  


Current Time: Fri Dec 02 16:35:10 CST 2016

Total time taken to generate the page: 0.24411 seconds