44 lines (38 loc) · 1.67 KB

title

sys.synonyms (Transact-SQL) | Microsoft Docs

ms.custom

ms.date

03/15/2017

ms.prod

sql-non-specified

ms.reviewer

ms.suite

ms.technology

database-engine

ms.tgt_pltfrm

ms.topic

language-reference

f1_keywords

sys.synonyms_TSQL

synonyms_TSQL

sys.synonyms

synonyms

dev_langs

TSQL

helpviewer_keywords

sys.synonyms catalog view

ms.assetid

d6e88ca6-6e3d-4f56-bd3e-d85e26be5499

caps.latest.revision

20

author

BYHAM

ms.author

rickbyh

manager

jhubbard

sys.synonyms (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-all_md]

Contains a row for each synonym object that is sys.objects.type = SN.

Column name	Data type	Description
<Columns inherited from sys.objects>		For a list of columns that this view inherits, see sys.objects (Transact-SQL).
base_object_name	nvarchar(1035)	Fully quoted name of the object to which the user of this synonym is redirected.

Permissions

[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.

See Also

Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)