title
sys.external_libraries (Transact-SQL) | Microsoft Docs
ms.custom
ms.date
10/05/2017
ms.prod
sql-server-2017
ms.reviewer
ms.suite
ms.technology
ms.tgt_pltfrm
ms.topic
language-reference
f1_keywords
external_libraries
external_libraries_TSQL
sys.external_libraries
sys.external_libraries_TSQL
dev_langs
helpviewer_keywords
sys.external_libraries catalog view
author
jeannt
ms.author
jeannt
manager
jhubbard
sys.external_libraries (Transact-SQL) [!INCLUDEtsql-appliesto-ssvnxt-xxxx-xxxx-xxx ]
Supports the management of package libraries related to external runtimes such as R or Python.
The catalog view sys.external_libraries lists a row for each external library that has been uploaded into the database.
Column name
Data type
Description
external_library_id
int
ID of the external library object.
name
sysname
Name of the external library. Is unique within the database per owner.
principal_id
int
ID of the principal that owns this external library.
language
sysname
Name of the language or runtime that supports the external library. Valid values are 'R'. Additional runtimes might be added in future.
scope
int
0 for public scope; 1 for private scope
scope_desc
varchar(7)
Indicates whether the package is public or private
sys.external_library_files CREATE EXTERNAL LIBRARY Package management for SQL Server R Services