synonym in SQL server 2005
How can one get the information about the object type of synonym that is whether the synonym belongs to function, stored procedure, table or view using a query. Sys.synonyms table contains information about synonyms present in a particular database but it does not tell for which object the synonym is created?

Answer Question   |  September 25, 2009  11:13 AM
SQL Server 2005, SQL Server Synonyms, SQL Server System Tables