Hi Friends Lets Understand What is Synonym It is the Schema object which is the alternate name for the database object. It avoids the Schema name entry to the database. Syntax:- Create Synonym <Synonym_name > For SCHEMA.OBJECT; Example:- CREATE SYNONYM GHAN for SCOTT.GHAN; NOTE :- Assuming GHAN is Database Table .
Posts
Showing posts with the label SQL Synonym