Posts

Showing posts with the label SQL Synonym
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 .