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: 13965
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: Sat Feb 15 20:58:52 CST 2025