title
sys.synonyms (Transact-SQL) | Microsoft Docs
ms.custom
ms.date
03/15/2017
ms.prod
sql
ms.prod_service
database-engine, sql-database, sql-data-warehouse, pdw
ms.reviewer
ms.technology
system-objects
ms.topic
language-reference
f1_keywords
sys.synonyms_TSQL
synonyms_TSQL
sys.synonyms
synonyms
dev_langs
helpviewer_keywords
sys.synonyms catalog view
ms.assetid
d6e88ca6-6e3d-4f56-bd3e-d85e26be5499
author
stevestein
ms.author
sstein
manager
craigg
monikerRange
>=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current
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.
[!INCLUDEssCatViewPerm ] For more information, see Metadata Visibility Configuration .
Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)