Skip to content

Latest commit

 

History

History
46 lines (40 loc) · 1.91 KB

File metadata and controls

46 lines (40 loc) · 1.91 KB

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.component: "system-catalog-views" ms.reviewer: "" ms.suite: "sql" ms.technology: system-objects 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: edmacauley ms.author: edmaca manager: craigg monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017"

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)