1.

What Is A Synonym? Why Would You Want To Create A Synonym?

Answer»

SYNONYM is a single-part name that can replace a two, three or four-part name in MANY SQL statements. Using SYNONYMS in RDBMS cuts down on typing.
SYNONYMs can be created for the following objects:

  • Table.
  •  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.

SYNONYM is a single-part name that can replace a two, three or four-part name in many SQL statements. Using SYNONYMS in RDBMS cuts down on typing.
SYNONYMs can be created for the following objects:


Discussion

No Comment Found

Related InterviewSolutions