What is synonym in sql
Posted on September 22nd , 2011 by Admin
|
|
Synonym is used to replace multipart name query to single part main purpose is to cut down the typing effort of user.We use synonym in RDBMS to save time of devloper. Synonym is alternate name assigned to a table, view, sequence or program unit. Synonym may be used to shadow the original name and owner of the actual entity. Synonym Extends the reach of tables, by allowing public access to the synonym. SYNONYMs can be created for the following objects: Tabl |
| e View Assembly (CLR) Stored Procedure Assembly (CLR) Table-valued Function Assembly (CLR) Scalar Function Assembly Aggregate (CLR) Aggregate Functions Replication-filter-procedure Extended Stored Procedure SQL Scalar Function SQL Table-valued Function SQL Inline-table-valued Function SQL Stored Procedure |
|
|
