A synonym is an alias that can be used for a table or view. It requires no storage space other than its definition in the system catalog. Using synonyms, users can access a table or view through the corresponding synonym without having to use the fully qualified name.
Example
The following creates a synonym named AllEmp for the AllEmployees table owned by User1; use the synonym AllEmp in place of the fully qualified table name
User1.AllEmployees in subsequent SQL statements.
CREATE SYNONYM AllEmp FOR User1.AllEmployees
Example
The following creates a synonym named AllEmp for the AllEmployees table owned by User1; use the synonym AllEmp in place of the fully qualified table name
User1.AllEmployees in subsequent SQL statements.
CREATE SYNONYM AllEmp FOR User1.AllEmployees
No comments:
Post a Comment