How SQL Server Synonyms Help Database DevOps

,

Synonyms inside SQL Server are one of those useful but forgotten features. A synonym is a database level object that allows you to provide an alternative name for another database object such as a view, user defined table, scalar function, stored procedure, inline table valued function (tvf), or extended stored procedure. They can also be used for CLR Assembly related stored procedures, CLR tvf, CLR scalar functions or even CLR aggregate functions.  There are many practical uses for synonyms, and I’ll explain how to create them and some use cases.

Read the full article here at Red-Gate’s Simple Talk

The post How SQL Server Synonyms Help Database DevOps appeared first on A Shot of SQLEspresso.

Original post (opens in new tab)
View comments in original post (opens in new tab)

Rate

Share

Share

Rate