sys.external_libraries (Transact-SQL)
Applies to: SQL Server 2017 (14.x) and later Azure SQL Managed Instance
Supports the management of package libraries related to external runtimes such as R, Python, and Java.
Note
In SQL Server 2017, R language and Windows platform are supported. R, Python, and Java on the Windows and Linux platforms are supported in SQL Server 2019 and later. On Azure SQL Managed Instance, R and Python are supported.
sys.external_libraries
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', 'Python', and 'Java'. 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 |